Filter
Top Products
1) Define a role.
Use the CREATE ROLE statement to define a role.
A sample role definition for defining role STOCKS_A2 follows.
Example:
2) Specify the privileges to be granted in the role.
Use the GRANT statement to specify the privileges to be granted in the role. In the defined role, specify the privileges
granted for accessing a table in a database.
The following table lists the privileges that can be defined in a role by using the GRANT statement.
An example of specifying privileges granted for individual tables in role STOCKS_A2 follows.
Example:
78