六
.1.2
用户
.................................................................................................................................63
六.2 TERADATA数据库的层次型结构......................................................................................63
CREATE USER USER2 FROM USERADMIN AS PERM = 20000000000,..............................65
SPOOL = 10000000000, PASSWORD = USER2;..........................................................................65
六.3 拥有者(OWNER)与创建者(CREATOR)...............................................................................66
GIVE APPL1 TO ADMIN2；..........................................................................................................66
SELECT PARENT FROM DBC.CHILDREN WHERE CHILD = 'APPL1';............................66
SELECT CHILD FROM DBC.CHILDREN WHERE PARENT = 'USERADMIN';................66
六.4 TERADATA数据库的访问权限..........................................................................................67
六
.4.1
访问权限概述
.................................................................................................................67
GRANT SELECT ON USERA TO USERB WITH GRANT OPTION;.....................................67
GRANT SELECT, INSERT ON ADMIN.TABLEC TO DBC;....................................................69
GRANT SELECT ON USERA TO ADMIN;..................................................................................69
GRANT SELECT ON USERA TO USERA WITH GRANT OPTION;.....................................70
GRANT TABLE, VIEW, MACRO, SELECT, INSERT, UPDATE,...........................................70
DELETE, DUMP, RESTORE, CHECKPOINT, EXECUTE.......................................................70
GRANT TABLE, VIEW, MACRO, SELECT, INSERT, UPDATE,...........................................70
DELETE, DUMP, RESTORE, CHECKPOINT, EXECUTE.......................................................70
GRANT USER, DATABASE, TABLE, VIEW, MACRO, SELECT,..........................................70
GRANT USER, DATABASE, TABLE, VIEW, MACRO, SELECT,..........................................71
REVOKE USER ON USERA FROM USERA;..............................................................................71
GRANT USER ON USERA TO USERA;.......................................................................................71
GRANT CREATE USER ON USERADMIN TO ADMIN2;........................................................72
CREATE USER USER9 FROM USERADMIN.............................................................................72
. III .
评论13
最新资源