Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Users can't see table
You can try this:
remove dba privilege from user xxx...
sql> select default_role from dba_role_privs where grantee='XXX';
if the select return "NO" for some roles, you have to do:
sql>alter user xxx default role all;
Now, it's will be ok..
Bye Received on Thu Feb 18 1999 - 09:41:23 CST