Object Privilege

[SANJAY_G]

Originally Posted by Upeshp:
If it is so...........and when i am executing the above written query ..i am not getting procedures, pakages, functions privileges listed in it.

Have a look at this..

sanjay@ORAM> select * from user_tab_privs
  2  where owner not in ('SYS','SYSTEM');

GRANTEE         OWNER           TABLE_NAME      GRANTOR         PRIVILEGE       GRA
--------------- --------------- --------------- --------------- --------------- ---
PUBLIC          SANJAY          SANJAY          SANJAY          SELECT          NO
PUBLIC          SANJAY          V_SANJAY        SANJAY          SELECT          NO

sanjay@ORAM> create procedure my_proc is
  2  begin
  3  null;
  4  end;
  5  /

Procedure created.

sanjay@ORAM> grant execute on my_proc to public;

Grant succeeded.

sanjay@ORAM> select * from user_tab_privs
  2   where owner not in ('SYS','SYSTEM');

GRANTEE         OWNER           TABLE_NAME      GRANTOR         PRIVILEGE       GRA
--------------- --------------- --------------- --------------- --------------- ---
PUBLIC          SANJAY          SANJAY          SANJAY          SELECT          NO
PUBLIC          SANJAY          V_SANJAY        SANJAY          SELECT          NO
PUBLIC          SANJAY          MY_PROC         SANJAY          EXECUTE         NO

HTH
Sanjay