Home » RDBMS Server » Security » Object/System privilege there.. Schema privilege there? (Oracle 11g)
Object/System privilege there.. Schema privilege there? [message #485892] Fri, 10 December 2010 22:18 Go to next message
prajjwal
Messages: 28
Registered: January 2008
Location: kolkata
Junior Member

Hi,
Suppose there are 4 schemas U1, U2, U3 and U4.

The following points needs to be taken care of--

1) U1 should have access on all the objects of schema U2.
2) U1 should not have access on any objects of schemas U3 and U4.
3) New objects will be added to U2 but nobody will make any changes to the grants. #1 should still always hold good.
4) No use of triggers to grant automated object privileges on object creation.
5) No use of loop back dblink.

Is this possible in oracle or the feature is missing?

Regards,
Prajjwal
Re: Object/System privilege there.. Schema privilege there? [message #485894 is a reply to message #485892] Fri, 10 December 2010 22:47 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>U1 should have access on all the objects of schema U2.
Does above mean SELECT only?
Does above mean DML (INSERT, UPDATE, DELETE) against U2 objects?
Does above mean DDL (DROP, TRUNCATE) against U2 objects?
Re: Object/System privilege there.. Schema privilege there? [message #485895 is a reply to message #485894] Fri, 10 December 2010 22:54 Go to previous message
prajjwal
Messages: 28
Registered: January 2008
Location: kolkata
Junior Member

Everything I would say.. select, DML, DDL.
Also if you can think of only select and DML, please let us know.

Thanks
Previous Topic: Restricting User access
Next Topic: grant Privileges to a user ,??
Goto Forum:
  


Current Time: Thu Mar 28 13:04:05 CDT 2024