OraFAQ Forum: SQL & PL/SQL » objects permissions????

Home » SQL & PL/SQL » SQL & PL/SQL » objects permissions????

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

objects permissions???? [message #230360]

Wed, 11 April 2007 11:55

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

Report message to a moderator

Re: objects permissions???? [message #230387 is a reply to message #230360]

Wed, 11 April 2007 13:45

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

dba_tab_privs

Report message to a moderator

Re: objects permissions???? [message #230521 is a reply to message #230360]

Thu, 12 April 2007 03:04

cefb
Messages: 56
Registered: March 2007

Member

still can't get info of all tables

Report message to a moderator

Re: objects permissions???? [message #230524 is a reply to message #230521]

Thu, 12 April 2007 03:07

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You'll get information only on all tables on which privileges have been granted.

Regards
Michel

Report message to a moderator

Re: objects permissions???? [message #230531 is a reply to message #230360]

Thu, 12 April 2007 03:11

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

Report message to a moderator

Re: objects permissions???? [message #230536 is a reply to message #230531]

Thu, 12 April 2007 03:23

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: objects permissions???? [message #230550 is a reply to message #230360]

Thu, 12 April 2007 03:36

cefb
Messages: 56
Registered: March 2007

Member

i am testing now with other users but i think is like you said

Report message to a moderator

Previous Topic:	Records not getting inserted
Next Topic:	Hours:MM:Seconds

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 05 20:19:41 CST 2024