select without needing owner for tablename
tsmoriJun 23 2009 — edited Jun 23 2009Sorry for the potentially simplistic/newbie question, but I can't seem to find the answer to this anywhere.
I have a user with the dba role in which I can perform the following statement:
dba_user> select * from users;
I have a second user, created to only have select privilege, when I run the same statement:
read_only_user> select * from users;
ORA-00942: table or view does not exist
I have to do it this way:
read_only_user> select * from dba_user.users;
Is there a way to modify the read_only_user so that I don't have to qualify the table names? I already have select statements in other code, so I'm hoping I can change the user privileges instead of having to go back and modify a lot of SQL.