OraFAQ Forum: Security » synonym how get info on how user has access to it

Home » RDBMS Server » Security » synonym how get info on how user has access to it (Oracle Database 11g Enterprise Edition Release 11.2.0.3.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

synonym how get info on how user has access to it [message #669483]

Tue, 24 April 2018 14:20

wtolentino
Messages: 421
Registered: March 2005

Senior Member

there is a synonym called CHIPS_MUNI and is based on a view called lps.muni_chips. this CHIPS_MUNI is used on forms application. basically all the user has access to the synonym CHIPS_MUNI.

i want to find out how does a user for example PREA has access to the synonym CHIPS_MUNI. since the all_ views are only limited and i can only use it for what i have access to, i can't see what PREA has. and since i do not have a dba data dictionary access i also cannot see what PREA has. now i asked for our database administrator help and they can't see how does PREA has access to the CHIPS_MUNI synonym. i think maybe they missed some data dictionary.

what dba data dictionary or if you have a query that uses dba dictionary and i can request it to be run by our dba. to get the info on how PREA has access to the synonym CHIPS_MUNI (grants, privileges, objects ...). that will be helpful.

thanks so much.

Report message to a moderator

Re: synonym how get info on how user has access to it [message #669484 is a reply to message #669483]

Tue, 24 April 2018 14:37

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>since the all_ views are only limited and i can only use it for what i have access to,
Which schema is "yours"?

post SQL & results that show how you obtain access to LPS.MUNI_CHIPS

select object_owner, object_type from all_objects where object_name = 'CHIPS_MUNI';

POST results from SQL above.

>i think maybe they missed some data dictionary.
Why does the problem lies with somebody else & not you.

Report message to a moderator

Re: synonym how get info on how user has access to it [message #669485 is a reply to message #669483]

Wed, 25 April 2018 00:32

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

There are no specific privileges on synonyms.
A user can "access" a synonym if he/she can access the base object (which may be far away in case of synonym of synonym of synonym of synonym...).

There are no views that sees that outside the account you want to know the privileges (it would be something like ALL_ALL_SYNONYMS).

Report message to a moderator

Re: synonym how get info on how user has access to it [message #669513 is a reply to message #669483]

Thu, 26 April 2018 13:45

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Any feedback?

Report message to a moderator

Previous Topic:	What encryption algorithm Oracle 12
Next Topic:	How to setup Password rotation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 02 15:49:44 CST 2025