Create table [message #548327] |
Wed, 21 March 2012 07:39 |
dba_7722
Messages: 197 Registered: August 2010 Location: Delhi
|
Senior Member |
|
|
Hello Expert,
I got query to investigate, how table owner is changed. Please suggest.
SQL> conn test/test
Connected.
SQL> create table guri(name varchar2(9));
Table created.
SQL> select table_name from user_tables;
no rows selected
SQL> conn /as sysdba
Connected.
SQL> select owner,object_name,object_type from dba_objects where object_name = 'GURI';
OWNER OBJECT_NAME OBJECT_TYPE
---------- ----------- ------------
CISREPLICA GURI TABLE
[EDITED by LF: fixed topic title typo; was "craete"]
[Updated on: Wed, 21 March 2012 08:54] by Moderator Report message to a moderator
|
|
|
|
|
|
|
Re: craete table [message #548362 is a reply to message #548361] |
Wed, 21 March 2012 09:52 |
cookiemonster
Messages: 13962 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
Assuming you did everything exactly as typed in the first post then John's explanation is almost certainly correct.
Look for a logon trigger.
|
|
|
|
|
Re: craete table [message #548552 is a reply to message #548530] |
Thu, 22 March 2012 17:58 |
cookiemonster
Messages: 13962 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
It also means the Test user has the CREATE ANY TABLE privilege. Which they really shouldn't have. No user should need that priv.
|
|
|