[阅读: 457] 2007-01-09 07:05:21
-- 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;