OraFAQ Forum: Server Administration » Equivalent Privilege in oracle 9i and 10g (merged)

Home » RDBMS Server » Server Administration » Equivalent Privilege in oracle 9i and 10g (merged)

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

Equivalent Privilege in oracle 9i and 10g (merged) [message #410891]

Tue, 30 June 2009 23:39

saifurshaon
Messages: 29
Registered: December 2007
Location: Dhaka

Junior Member

Dear All,
for accessing 10G DB from 9i OEM i got below error like this

SELECT ANY DICTIONARY privilege should be granted.

But in 10G there is no privilage named SELECT ANY DICTIONARY.
So can any one tell me what will be the exact privileges which can be given to a normal user so that he can access the 10g database using 9i OEM.

Report message to a moderator

Re: Equivalent Privilege in oracle 9i and 10g (merged) [message #410903 is a reply to message #410891]

Wed, 01 July 2009 00:36

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

Senior Member
Account Moderator

Quote:

But in 10G there is no privilage named SELECT ANY DICTIONARY.

You're wrong:

SQL> Select name
  2  from system_privilege_map
  3  where name = 'SELECT ANY DICTIONARY';
NAME
----------------------------------------
SELECT ANY DICTIONARY

1 row selected.

SQL> @v

Version Oracle : 10.2.0.4.0

Regards
Michel

Report message to a moderator

Re: Equivalent Privilege in oracle 9i and 10g (merged) [message #410959 is a reply to message #410891]

Wed, 01 July 2009 05:20

saifurshaon
Messages: 29
Registered: December 2007
Location: Dhaka

Junior Member

Hi Cadot,
thanks for your reply.
Actually i missed one thing. I need to know the similar privilege or set of privileges of select_catalog_role which is in 9i. In 10G I need the equivalent privilege name.

Report message to a moderator

Re: Equivalent Privilege in oracle 9i and 10g (merged) [message #410971 is a reply to message #410959]

Wed, 01 July 2009 06:09

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

Senior Member
Account Moderator

Maybe the same name? Did you check it?

Regards
Michel

Report message to a moderator

Re: Equivalent Privilege in oracle 9i and 10g (merged) [message #411281 is a reply to message #410891]

Thu, 02 July 2009 23:24

animesh_nz19
Messages: 7
Registered: July 2009

Junior Member

SELECT_CATALOG_ROLE is present in 10G also.

SQL> grant select_catalog_role to akm;

Grant succeeded.

SQL> select banner from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod
PL/SQL Release 10.2.0.3.0 - Production
CORE 10.2.0.3.0 Production
TNS for 32-bit Windows: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 - Production

SQL> conn akm/akm
Connected.
SQL> select * from session_roles;

ROLE
------------------------------
CONNECT
RESOURCE
SELECT_CATALOG_ROLE

Regards,
Animesh

Report message to a moderator

Re: Equivalent Privilege in oracle 9i and 10g (merged) [message #411282 is a reply to message #410891]

Thu, 02 July 2009 23:30

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

ROLE not equal privilege.
Privilege acquired via ROLE do not apply within PL/SQL procedure.

Report message to a moderator

Previous Topic:	USER1234 dedicated to instance PROD1 (merged 6)
Next Topic:	Huge trace generated in udump

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 13:39:06 CST 2024