Granting System Privileges to a User : System Privileges « User Privilege « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. User Privilege
  3. System Privileges
GRANT CREATE SESSION, CREATE USER, CREATE TABLE TO yourUserName;








36.9.System Privileges
36.9.1.System Privileges
36.9.2.Granting System Privileges to a User
36.9.3.Use WITH ADMIN OPTION to enable a user to grant a privilege to another user
36.9.4.The EXECUTE ANY PROCEDURE can then be granted to another user
36.9.5.Grant a privilege to all users by granting to PUBLIC
36.9.6.Revoke system privileges from a user using REVOKE