16.10 - Specific User Category Privileges

16.10 - Specific User Category Privileges - Teradata Database

Teradata Database Administration

Product

Teradata Database

Release Number

16.10

Published

April 2018

Language

English (United States)

Last Update

2018-04-26

dita:mapPath

qjg1509413559832.ditamap

dita:ditavalPath

changebar_rev_16_10_exclude_audience_ie.ditaval

dita:id

ujp1472240543947

The following table indicates the specific privileges granted to each user category.

User Category	Database Object Type	Privileges Granted
Normal	QCD tables	INSERT UPDATE SELECT on the following tables. IndexRecommendations SeqNumber TableStatistics DELETE on the AnalysisLog table
	X views	SELECT
	X macros	EXEC
	Non-X views	None
	Non-X macros	None
Power	QCD tables	INSERT UPDATE SELECT on the following tables: IndexRecommendations SeqNumber TableStatistics DELETE on the AnalysisLog table
	X views	SELECT
	X macros	EXEC
	Non-X views	SELECT
	Non-X macros	EXEC (excluding DELETE plan and workload macros)
Administrator	QCD tables	DELETE DROP INSERT SELECT UPDATE
	X views X views use the value for UDB_Key in the Query table to restrict access to request plans to the user who captures them, while the Non-X views do not restrict that access.	DELETE DROP INSERT SELECT UPDATE
	X macros	DROP EXECUTE
	Non-X views	DELETE DROP INSERT SELECT UPDATE
	Non-X macros	DROP EXECUTE