Answer :

GRANT statementUse the GRANT statement to give privileges to a specific user or role, or to all users, to perform actions on database objects. You can also use the GRANT statement to grant a role to a user, to PUBLIC, or to another role.The following types of privileges can be granted:Delete data from a specific table.Insert data into a specific table.Create a foreign key reference to the named table or to a subset of columns from a table.Select data from a table, view, or a subset of columns in a table.Create a trigger on a table.Update data in a table or in a subset of columns in a table.Run a specified function or procedure.Use a sequence generator or a user-defined type.
The syntax for granting privileges on a table in Oracle is:GRANT privileges ON object TO user;

Other Questions