Re: 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

--
http://www.freelists.org/webpage/oracle-l