Fergal Taheny wrote,on my timestamp of 29/05/2012 6:27 AM: > Hi, > Another feature I would like to see and its kind of related to what Nuno > mentioned is the ability to grant privileges on a schema level as well as a > object level. > > I've done another table driven trigger based solution for this so when any > tables or views are created in a schema, privileges are automatically > granted to certain roles/users. > > If anyone wants the code, give me a shout. > Oh, nifty! Good idea! -- Cheers Nuno Souto in sunny Sydney, Australia dbvision@xxxxxxxxxxxx -- //www.freelists.org/webpage/oracle-l