Home » SQL & PL/SQL » SQL & PL/SQL » objects permissions????
objects permissions???? [message #230360] Wed, 11 April 2007 11:55 Go to next message
cefb
Messages: 56
Registered: March 2007
Member
hi all!!!


is there any way of checking the objects permissions (select,execute)?
i used
select * from all_tab_privs 

but i can't get information from all tables in the database.

i am using Oracle 9i with Windows XP


Thanks
Re: objects permissions???? [message #230387 is a reply to message #230360] Wed, 11 April 2007 13:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

dba_tab_privs
Re: objects permissions???? [message #230521 is a reply to message #230360] Thu, 12 April 2007 03:04 Go to previous messageGo to next message
cefb
Messages: 56
Registered: March 2007
Member
still can't get info of all tables
Re: objects permissions???? [message #230524 is a reply to message #230521] Thu, 12 April 2007 03:07 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You'll get information only on all tables on which privileges have been granted.

Regards
Michel
Re: objects permissions???? [message #230531 is a reply to message #230360] Thu, 12 April 2007 03:11 Go to previous messageGo to next message
cefb
Messages: 56
Registered: March 2007
Member
ok.
but i tested and i can use tables that aren't listed in all_tab_privs.



thanks
Re: objects permissions???? [message #230536 is a reply to message #230531] Thu, 12 April 2007 03:23 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Maybe you are the owner.

Post what you query, what you see and so on to "prove" your case.

Regards
Michel
Re: objects permissions???? [message #230550 is a reply to message #230360] Thu, 12 April 2007 03:36 Go to previous message
cefb
Messages: 56
Registered: March 2007
Member
i am testing now with other users but i think is like you said
Previous Topic: Records not getting inserted
Next Topic: Hours:MM:Seconds
Goto Forum:
  


Current Time: Thu Dec 08 23:55:12 CST 2016

Total time taken to generate the page: 0.09067 seconds