Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2003
    Posts
    35

    Question Unanswered: Printing Who's got what Priveleges

    Hey There.
    I would like to know if there is a way, hopefully easy and quick to show in sql plus, a user and there priveleges to certain tables.
    I need to do a grant select..... for a user on some of my tables, and I would like to know if there is a query I could run that would show that the user know has select priveleges.
    "My Idea is that everyone should be required to use small fonts. That way we'll save disk space.
    ~Asok.

  2. #2
    Join Date
    Mar 2004
    Location
    Berkshire, UK
    Posts
    186
    try SELECT * FROM all_tab_privs WHERE grantee = <user>
    There are 10 types of people in the world, those that know Binary and those that don't.

  3. #3
    Join Date
    Mar 2004
    Location
    Berkshire, UK
    Posts
    186
    SELECT * FROM dict WHERE table_name LIKE '%PRIV%'

    will show you all the other privelege tables
    There are 10 types of people in the world, those that know Binary and those that don't.

  4. #4
    Join Date
    Jan 2003
    Posts
    35

    Wink

    thanks.
    select * from all_tab_privs WHERE grantee = <user> helped. Exactly what I needed.
    "My Idea is that everyone should be required to use small fonts. That way we'll save disk space.
    ~Asok.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •