Filter
Top Products
Example:
Adds role STOCKS_A2.
Specify the privileges to be granted in role STOCKS_A2.
Grant the privileges of role STOCKS_A2 to users.
Altering role privilege information (GRANT statement)
To alter the role privileges for a table, use the GRANT statement.
Example:
Adds privileges for the STOCK table to role STOCKS_A2.
Deleting a role definition (DROP ROLE statement)
To delete a role definition, use the DROP ROLE statement. When a role is deleted, the privileges to be granted as
defined with the GRANT statement in the role are also deleted, and the role privileges granted to users are removed.
Example:
Deletes role STOCKS_A2.
Deleting/removing role privileges (REVOKE statement)
To delete a privilege from a role or remove the role privileges from a user, use the REVOKE statement.
Example 1:
Deletes the SELECT privilege for the STOCK table from role STOCKS_A2.
131