| Bishal |
Posted: May 01, 2008 01:34:13 AM |
Total Post: 207
Joined: Apr, 2008
|
Please tell me the query to view the tables tat are created by particular users..
how to fid it? |
|
|
 Mohammed Taj |
| Posted: May 01, 2008 01:55:28 AM |  |
|
Total Post: 746
Joined: Jul, 2007
|
DBA_USERS.TABLE_NAME WHERE OWNER='PARTICULAR USER';
OR
CONNECT WITH PARTICULAR USER
SELECT * FROM TAB;
OR
SELECT TABLE_NAME FROM USER_TABLES;
|
|
|
|
|
| Bishal |
| Posted: May 01, 2008 02:00:30 AM | |
|
Total Post: 207
Joined: Apr, 2008
|
i cant connect to all te users as i dont have password for all of them..
i am connected as sysdba
Now what should be done?
|
|
|
|
|
| Murtuja |
| Posted: May 01, 2008 02:10:08 AM | |
|
Total Post: 857
Joined: Jan, 2006
|
Hi
SELECT *
FROM dba_objects
WHERE object_type = 'TABLE';
SELECT * FROM dba_tables;
|
|
|
|
|
| Bishal |
| Posted: May 01, 2008 02:19:22 AM | |
|
Total Post: 207
Joined: Apr, 2008
|
|
|
|
|
| Mohammed Taj |
| Posted: May 01, 2008 02:49:47 AM | |
|
Total Post: 746
Joined: Jul, 2007
|
..SELECT *
FROM dba_objects
WHERE object_type = 'TABLE';...
You forget to add "OWNER" column :) becuase OP want to know particular schema tables.
|
|
|
|
|
| Murtuja |
| Posted: May 01, 2008 02:57:20 AM | |
|
Total Post: 857
Joined: Jan, 2006
|
Hi,
Does it make any difference when DBA knows SQL ?
|
|
|
|
|
| http://shaharear.blogspot.com |
| Posted: May 01, 2008 06:07:50 AM | |
|
Total Post: 135
Joined: Apr, 2008
|
hi guys why you r trying harder way
its so simple
log on that user and select * from tab;
|
|
|
|
|
| Murtuja |
| Posted: May 01, 2008 06:32:48 AM | |
|
Total Post: 857
Joined: Jan, 2006
|
Hi Hasan,
If we have DBA previleges then we can get user wise list of all table in single query and that's why we need to query either DBA_TABLES or DBA_OBJECTS.
|
|
|
|
|
| http://shaharear.blogspot.com |
| Posted: May 01, 2008 07:01:57 AM | |
|
Total Post: 135
Joined: Apr, 2008
|
yap ... I know this ..
but the requirement was
"Please tell me the query to view the tables tat are created by particular user"
so if the particular user does not have DBA privilege how can he quarry on the DBA_TABLES or DBA_OBJECTS view
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
