whybas.blogg.se

If you had granted ALL privileges to public (all users) on the suppliers table and you wanted to revoke these privileges, you could run the following REVOKE statement: REVOKE ALL ON suppliers FROM public If you wanted to revoke ALL privileges on a table for a user named anderson, you could use the ALL keyword as follows: REVOKE ALL ON suppliers FROM anderson Let's look at some examples of how to revoke privileges on tables in Oracle.įor example, if you wanted to revoke DELETE privileges on a table called suppliers from a user named anderson, you would run the following REVOKE statement: REVOKE DELETE ON suppliers FROM anderson user The name of the user that will have these privileges revoked. In the case of revoking privileges on a table, this would be the table name.

Object The name of the database object that you are revoking privileges for. For example: GRANT SELECT ON suppliers TO public If you wanted to grant only SELECT access on your table to all users, you could grant the privileges to the public keyword. For example: GRANT ALL ON suppliers TO smithj You can also use the ALL keyword to indicate that you wish ALL permissions to be granted for a user named smithj. Let's look at some examples of how to grant privileges on tables in Oracle.įor example, if you wanted to grant SELECT, INSERT, UPDATE, and DELETE privileges on a table called suppliers to a user name smithj, you would run the following GRANT statement: GRANT SELECT, INSERT, UPDATE, DELETE ON suppliers TO smithj user The name of the user that will be granted these privileges. In the case of granting privileges on a table, this would be the table name. Object The name of the database object that you are granting privileges for. Ability to perform SELECT statements on the table.Ībility to perform INSERT statements on the table.Ībility to perform UPDATE statements on the table.Ībility to perform DELETE statements on the table.Ībility to create a constraint that refers to the table.Ībility to perform ALTER TABLE statements to change the table definition.Ībility to create an index on the table with the create index statement.