Home » RDBMS Server » Security » system privileges (9i Rel2 on Sun OS 5.8)
system privileges [message #476366] Wed, 22 September 2010 15:55 Go to next message
contactrb
Messages: 1
Registered: September 2010
Junior Member
Hi Everyone,

Can you clarify thes below listed system privileges (I am using Oracle v9iRel2 - due to application restriction)

with these system privs, what is the type of acess/functionality it provides ?

ADMINISTER profile

CREATE SECURITY PROFILE

CREATE ANY SECURITY PROFILE

DROP ANY SECURITY PROFILE

ALTER ANY SECURITY PROFILE


Is above privileges different than the below listed privs ?

CREATE SECURITY PROFILE

DROP SECURITY PROFILE

ALTER SECURITY PROFILE


Thanks.

Ram


Incase you have any doc / link that explains these sys privs, atleast that will be helpful.

I have searched and read few docs out there, but no details in that doc except just listing from system_privilege_map.

Re: system privileges [message #476386 is a reply to message #476366] Thu, 23 September 2010 00:58 Go to previous message
Michel Cadot
Messages: 66643
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database SQL Reference
http://www.oracle.com/pls/db102/homepage and use "Quick Search" field.

Regards
Michel

[Updated on: Thu, 23 September 2010 00:58]

Report message to a moderator

Previous Topic: How to get statement_type from procedure called in handler_module [DBMS_FGA]
Next Topic: Resource Access Descriptor & SSO
Goto Forum:
  


Current Time: Fri Oct 18 13:27:16 CDT 2019