OraFAQ Forum: Security » system privileges

Home » RDBMS Server » Security » system privileges (9i Rel2 on Sun OS 5.8)

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

system privileges [message #476366]

Wed, 22 September 2010 15:55

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.

Report message to a moderator