Home » RDBMS Server » Server Administration » privileges from one schema to other (windows)
privileges from one schema to other [message #542828] Fri, 10 February 2012 05:28 Go to next message
sandeip
Messages: 23
Registered: May 2011
Location: pune
Junior Member
I have 10 important schemas in my database,and i want to give only select privileges from SCHEMA PRODUSER to other 10 schemas. And also want that the new objects that are created in PRODUSER after granting the privileges are also have select privileges. Is it possible that i should directly grant select privileges from one schema to other without granting via individual objects(script to grant individual privileges from individual objects)

Details are as below:
database version: 9.2.0.8.0
OS version:
Microsoft Windows Server 2003
Standard Edition
Service Pack 2

Report message to a moderator

Re: privileges from one schema to other [message #542833 is a reply to message #542828] Fri, 10 February 2012 06:15 Go to previous message
Michel Cadot
Messages: 68641
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
i want to give only select privileges from SCHEMA PRODUSER to other 10 schemas

Create a role, grant the privileges to the role and grant the role to the other schemas.

Regards
Michel

Report message to a moderator

Previous Topic: Jobs at oracle upgrade
Next Topic: Installation of 11g
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 01:10:41 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.