Members   Search   Help    Register    Login   Home
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.
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 Go to previous messageGo to next message
Michel Cadot
Messages: 28993
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
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 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.
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 Go to previous messageGo to next message
Michel Cadot
Messages: 28993
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
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 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
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 Go to previous message
BlackSwan
Messages: 3227
Registered: January 2009
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Nov 9 01:47:22 CST 2009

Total time taken to generate the page: 0.02153 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.