Home » RDBMS Server » Server Administration » Equivalent Privilege in oracle 9i and 10g (merged)
Equivalent Privilege in oracle 9i and 10g (merged) [message #410891] Tue, 30 June 2009 23:39 Go to next message
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.
Re: Equivalent Privilege in oracle 9i and 10g (merged) [message #410903 is a reply to message #410891] Wed, 01 July 2009 00:36 Go to previous messageGo to next message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Equivalent Privilege in oracle 9i and 10g (merged) [message #410959 is a reply to message #410891] Wed, 01 July 2009 05:20 Go to previous messageGo to next message
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.
Re: Equivalent Privilege in oracle 9i and 10g (merged) [message #410971 is a reply to message #410959] Wed, 01 July 2009 06:09 Go to previous messageGo to next message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Maybe the same name? Did you check it?

Regards
Michel
Re: Equivalent Privilege in oracle 9i and 10g (merged) [message #411281 is a reply to message #410891] Thu, 02 July 2009 23:24 Go to previous messageGo to next message
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
Re: Equivalent Privilege in oracle 9i and 10g (merged) [message #411282 is a reply to message #410891] Thu, 02 July 2009 23:30 Go to previous message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
ROLE not equal privilege.
Privilege acquired via ROLE do not apply within PL/SQL procedure.
Previous Topic: USER1234 dedicated to instance PROD1 (merged 6)
Next Topic: Huge trace generated in udump
Goto Forum:
  


Current Time: Tue Dec 06 04:33:21 CST 2016

Total time taken to generate the page: 0.18296 seconds