Privileges and security
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Privileges and security

  1. #1
    Join Date
    Jan 2002
    Posts
    474

    Privileges and security

    when I query TABLE_PRIVILEGES and I have select priv, insert priv, update priv, etc and I have Y or N under those privileges, howevever, I also had A so what is the A mean ??? Is that with GRANT option ????

    and I notice that the A only show in insert priv and update priv.

    any idea???
    Last edited by ashley75; 12-04-2002 at 10:30 AM.

  2. #2
    Join Date
    Jan 2002
    Posts
    474
    any suggestions ????

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    here we go

    spam

  4. #4
    Join Date
    May 2001
    Location
    Maryland, USA
    Posts
    409
    This Table is absolute now. Use dba_sys_privs and dba_tab_privs instead. Comming back to your query, that field also have values like 'G' apart from values 'A' and 'Y' and 'N'. So i guess that is related to GRANT and ADMIN option repectively.
    -- Dilip

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