Answers

2015-02-14T16:14:54+05:30
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.
0
  • Brainly User
2015-02-18T18:49:55+05:30
The syntax for granting privileges on a table in Oracle is:GRANT privileges ON object TO user;
0