Viewing Privilages with SQL Plus

[carmo]

Using SQL plus, how can I see what privilages I have for a certain table in a database?

 

[SantaMufasa]

Here is code that should do what you want. If you want a specific table, just add the appropriate WHERE clause. (I ran the script, below, as user TEST, after receiving the following grant from user DHUNT: "GRANT SELECT ON s_emp TO test;&quot

col tabname heading "Table|Name" format a30
col privilege format a15

select owner||'.'||table_name tabname, privilege from user_tab_privs_recd;

Table
Name PRIVILEGE
------------------------------ ---------------
DHUNT.S_EMP SELECT