Results 1 to 2 of 2

Thread: ORACLE - user permissions

  1. #1
    Join Date
    May 2005
    Posts
    111

    ORACLE - user permissions

    two questions:
    1.) What is the sql syntax to list all users that have select rights to a specific table?
    2.) What is the sql syntax to grant select rights for a specific user to a specific table?

  2. #2
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    1. Query DBA_TAB_PRIVS
    2. GRANT SELECT ON table TO user

    go to http://tahiti.oracle.com for documentation.

Posting Permissions

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