Home » RDBMS Server » Security » Accessing list of the objects
Accessing list of the objects [message #218403] Thu, 08 February 2007 01:23 Go to next message
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
Re: Accessing list of the objects [message #218413 is a reply to message #218403] Thu, 08 February 2007 02:19 Go to previous messageGo to next message
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';

Re: Accessing list of the objects [message #218456 is a reply to message #218403] Thu, 08 February 2007 05:33 Go to previous message
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 ?
Previous Topic: How many maximum Redo Logfiles one can have in a Database
Next Topic: AUDIT PROGRAMS
Goto Forum:
  


Current Time: Thu Mar 28 11:30:15 CDT 2024