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

Thread: user priviliges

  1. #1
    Join Date
    Jan 2001
    How can I get info on which rights the current user has to a table?
    I saw the faq on using

    select table_name from all_tables;

    the problem is that this only gives info on whether or not the user has access to a certain table,
    but I especially need info on whether the user can make inserts, update, delete, selects, etc.

    Thanks in advance for any help


  2. #2
    Join Date
    Feb 2000
    Washington DC
    Try DBA_TAB_PRIVS view. It should be having the details you wanted.

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.