DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: System Privileges...

Hybrid View

  1. #1
    Join Date
    Oct 2000
    Posts
    10
    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

  2. #2
    Join Date
    Oct 2000
    Location
    Halifax, Nova Scotia
    Posts
    197
    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

  3. #3
    Join Date
    Oct 2000
    Posts
    10
    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
  •  


Click Here to Expand Forum to Full Width