Privileges and security

[ashley75]

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???

[ashley75]

any suggestions ????

[pando]

here we go

spam

[patel_dil]

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.