why ·
·
阅读: 503
自已新建的一個用戶,腳本如內:
-- Create the user
create user TPM
identified by ""
default tablespace USERS
temporary tablespace TEMP
profile DEFAULT;
-- Grant/Revoke object privileges
grant select, insert, update, delete on ALL_ALL_TABLES to TPM with grant option;
-- Grant/Revoke role privileges
grant dba to TPM with admin option;
-- Grant/Revoke system privileges
grant administer any sql tuning set to TPM with admin option;