| Schema error !! [message #55033] |
Fri, 27 December 2002 11:20  |
Amit Kumar
Messages: 23
Registered: July 1999
|
Junior Member |
|
|
Hi,
I have a curious problem :
I have created a user 'userschema'. When I log in as userschema and createa table it gives me the error - insufficient privileges. However it creates the table if i create it as : userschema.tablename.
I cannot select or desc the table with simple login. I have to chnage session as ' alter session set current_schema=userschema'. This is surprising, since I am anyway logged in as userschema !!!!!
So, now my basic problem is - how do I get rid of the insufficient privilege error ? The userschema has CONNECT ROLE with create table privileges.
|
|
|
|
| Re: Schema error !! [message #55036 is a reply to message #55033] |
Fri, 27 December 2002 14:15  |
Amit Kumar
Messages: 23
Registered: July 1999
|
Junior Member |
|
|
Hi folks :
I finally resolved it. First of all, a better way to see current_schema is select sys_context( 'userenv',
'current_schema' ) from dual; rather than sho user.
I had created an ON LOGON trigger on another user. However, I created it ON DATABASE rather than ON SCHEMA, hence any user loggin in was logged onto another schema.
Amit
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
