Friday, October 9, 2009

oracle: grant all permission to one user

the command is
grant all privileges to TESTUSER;

see below:

SQL> create user TESTUSER identified by TESTUSER
2 ;

User created.

SQL> grant all privileges to TESTUSER;

Grant succeeded.


SQL> select count(*),grantee from dba_sys_privs where grantee = 'TESTUSER' group by grantee;

COUNT(*) GRANTEE
---------- ------------------------------
139 TESTUSER

No comments:

Post a Comment