oracle grant all on to,Oracle-授予所有特权？(Oracle- GRANT ALL PRIVILEGES?)

最新推荐文章于 2024-06-28 19:34:52 发布

旺平商行

最新推荐文章于 2024-06-28 19:34:52 发布

阅读量1k

点赞数

文章标签： oracle grant all on to

You can grant all [privileges] on , but you aren't specifying an object; so you are granting system privileges:

Oracle Database provides the ALL PRIVILEGES shortcut for granting all the system privileges listed in Table 18-1, except the SELECT ANY DICTIONARY, ALTER DATABASE LINK, and ALTER PUBLIC DATABASE LINK privileges.

System privileges are not always restricted to a schema. That table includes a lot of ANY privileges, which are specifically not restricted to a schema. If you grant all privileges to a user they will be able to create or alter a table in any schema, for example. That probably isn't what you want.

There is no shortcut to grant only schema-restricted privileges. You'll need to grant CREATE TABLE, CREATE INDEX, etc. explicitly.

It's common practice to create a role to which you grant the necessary privileges, and then you just have to grant that role to your users. (Although you sometimes still need to grant privileges directly to users, e.g. if they are required in a stored procedure).