OraFAQ Forum: Security » Accessing list of the objects

Home » RDBMS Server » Security » Accessing list of the objects

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

Accessing list of the objects [message #218403]

Thu, 08 February 2007 01:23

amit_nanote
Messages: 56
Registered: July 2005
Location: Indore

Member

Hi all,

I am once againg with the user's object access problem.

I am having a user A having a1,a2,a3,a4 tables in that schema.

There is another user, B which is having access (select, insert, update, delete) of the user A's object.

Now I want to see the list of the objects of the B. How it is possible to get.

I dont want to user All_tab_columns
regds
Amit

Report message to a moderator

Re: Accessing list of the objects [message #218413 is a reply to message #218403]

Thu, 08 February 2007 02:19

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
Now I want to see the list of the objects of the B

conn SYS users
select object_name
from dba_objects
where owner = 'B';

conn B user
select object_name
from user_objects;

or if you A have SELECT ANY TABLE privs. 
then
conn A users
select object_name
from dba_objects
where owner = 'B';

Report message to a moderator

Re: Accessing list of the objects [message #218456 is a reply to message #218403]

Thu, 08 February 2007 05:33

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Your question is unclear. Are you asking how can user B list the objects of user A? If so, what is wrong with checking ALL_OBJECTS ?

Report message to a moderator

Previous Topic:	How many maximum Redo Logfiles one can have in a Database
Next Topic:	AUDIT PROGRAMS

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 31 13:32:31 CDT 2023