Re: grants on a schema

From: Yong Huang <>
Date: Sat, 12 Jan 2013 10:48:27 -0800 (PST)
Message-ID: <>

> can you do grants on a schema?

As others have said, Oracle does not have this statement. You have to grant privilege on each object of that schema to the grantee, either automated or manually. Also, when the schema has new objects in the future, you have to remember to grant again.

Oracle sometimes provides us new features that sound useful, probably took them a great deal of effort, but are not widely used by customers (e.g. edition-based redefinition). On the other hand, presumably low-hanging fruits that could be very useful to us are never considered, such as grant on a schema.

By the way, if your intention is to reduce the number of transactions for many grants, "create schema" may work: create schema authorization theschema
 grant select on t1 to thegrantee
 grant select on t2 to thegrantee;
That doesn't necessarily reduce total redo size though.

Yong Huang

Received on Sat Jan 12 2013 - 19:48:27 CET

Original text of this message