-
Hi Gurus,
What is the difference between the views DBA_SYS_PRIVS and SESSION_PRIVS ?
Can you give an example?
Thanks a lot.
Cheers * * * * * * * * * * * Aru
arumugam_pradeep@yahoo.com
-
DBA_SYS_PRIVS contains all system privileges held by all users or roles.
SESSION_PRIVS displays all system privileges that user has for that session whether it is from a role or from a direct grant
Ex: Say your username is USER amd you have access to a role called ROLE and it contains CREATE SESSION, CREATE USER, CREATE TABLE, CREATE INDEX. If you do a select on SESSION_PRIVS you will get a list of these privileges.
But if you do a select on DBA_SYS_PRIVS you will not see USER as having access to these privileges but you will see ROLE as having access to them
Basicaly SESSION_PRIVS is used to see what privileges you have been granted whether it be directly or by a role, and DBA_SYS_PRIVS shows all privileges granted and to what user or role
Hope Ididn't ramble too bad and this helps you out
-
Thanks brhynold,
That was good one.
I wanted to share with guys that I passed the first 8i OCP exam (Architecture amnd administration).
I Prepared with STS and Cramsession. They were reaally useful.
Cheers * * * * * * * * * * * Aru
arumugam_pradeep@yahoo.com
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|