3.5.3 Granting and Revoking Privileges

Use the GRANT PRIVILEGE command to grant privileges to roles for Oracle Exadata System Software users.

• Grant privileges to roles using the GRANT PRIVILEGE command.

  • The following example grants all privileges to Oracle Exadata System Software users with the admin role.

    CellCLI> GRANT PRIVILEGE ALL ACTIONS ON ALL OBJECTS TO ROLE admin

  • You can also grant individual command privileges to a role.

    CellCLI> GRANT PRIVILEGE list ON griddisk TO ROLE diskmonitor

  • You can also grant all command privileges for specific objects to a role.

    CellCLI> GRANT PRIVILEGE ALL ACTIONS ON griddisk TO ROLE diskadmin

• You can revoke privileges from roles using the REVOKE PRIVILEGE command.

  CellCLI> REVOKE PRIVILEGE ALL ACTIONS ON griddisk FROM ROLE diskadmin