Saved Bookmarks
| 1. |
What is the syntax for grant permission to the user in oracle? |
|
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. |
|