Q
Problem solve Get help with specific problems with your technologies, process and projects.

Is it possible to granting privileges on a schema level?

Published: 27 Apr 2005
Is there a simple way to grant privileges on a schema level?
No, privileges are granted at the object level (table, view, sequence, etc.) or are system privileges (create table, create procedure, etc.). The "any" privileges, such as "select any table" or "create any table" are system privileges, but they are more than schema-wide, they are database-wide.

Dig Deeper on Oracle database security

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close