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
Friday, October 9, 2009
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment