Showing posts with label How to grant all privileges in Oracle. Show all posts
Showing posts with label How to grant all privileges in Oracle. Show all posts

Wednesday, March 16, 2011

How to grant all privileges in Oracle

SQL>


SQL> sho user


USER is "SYSTEM"


SQL> select * from system_privilege_map


-- Create a new user


SQL> create user siva identified by sivag;


User created.


SQL> -- connect as siva and grant all privileges to siva


SQL> connect siva / sivag


Connected.


SQL> grant all privileges to siva;


Grant succeeded.