在Teradata数据库中存储的权限相关数据均为简写,为了方便记忆,这里将其各自的意义整理如下:
'AE' --> 'ALTER EXTERNAL PROCEDURE'
'AF' --> 'ALTER FUNCTION'
'AP' --> 'ALTER PROCEDURE'
'AS' --> 'ABORT SESSION'
'CA' --> 'CREATE AUTHORIZATION'
'CD' --> 'CREATE DATABASE'
'CE' --> 'CREATE EXTERNAL PROCEDURE'
'CG' --> 'CREATE TRIGGER'
'CM' --> 'CREATE MACRO'
'CO' --> 'CREATE PROFILE'
'CP' --> 'CHECKPOINT'
'CR' --> 'CREATE ROLE'
'CT' --> 'CREATE TABLE'
'CU' --> 'CREATE USER'
'CV' --> 'CREATE VIEW'
'D' --> 'DELETE'
'DA' --> 'DROP AUTHORIZATION'
'DD' --> 'DROP DATABASE'
'DF' --> 'DROP FUNCTION'
'DG' --> 'DROP TRIGGER'
'DM' --> 'DROP MACRO'
'DO' --> 'DROP PROFILE'
'DP' --> 'DUMP'
'DR' --> 'DROP ROLE'
'DT' --> 'DROP TABLE'
'DU' --> 'DROP USER'
'DV' --> 'DROP VIEW'
'E' --> 'EXECUTE (MACRO)'
'EF' --> 'EXECUTE FUNCTION'
'I' --> 'INSERT'
'IX' --> 'INDEX'
'MR' --> 'MONITOR RESOURCE'
'MS' --> 'MONITOR SESSION'
'PC' --> 'CREATE PROCEDURE'
'PD' --> 'DROP PROCEDURE'
'PE' --> 'EXECUTE PROCEDURE'
'R' --> 'RETRIEVE/SELECT'
'RF' --> 'REFERENCE'
'RS' --> 'RESTORE'
'RO' --> 'REPLICATION CONTROL or REPLICATION OVERIDE'
'SR' --> 'SET RESOURCE RATE'
'SS' --> 'SET SESSION RATE'
'U' --> 'UPDATE'
'UM' --> 'UDT METHOD'
'UT' --> 'UDT TYPE'
'UU' --> 'UDT USAGE'
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/16723161/viewspace-1019246/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/16723161/viewspace-1019246/