oracle – GRANT privileges

GRANT privileges ON object TO user;

privileges

• SELECT
• INSERT
• UPDATE
• DELETE
• REFERENCES
• ALTER
• INDEX
• ALL

object

• database object that you are granting privileges for. In the case of granting privileges on a table, this would be the table name.

user

• the name of the user that will be granted these privileges.

Examples:

GRANT SELECT, INSERT, UPDATE, DELETE ON object_name TO user_name;

GRANT ALL ON object_name TO user_name;

GRANT SELECT ON object_name TO user_name;