I have searched for many posts to achieve the below problem. But could not get the solution. Can some one resolve this please.
Problem. I have created a user/Schema with name RAMFULL with connect,resource privileges granted. and I want to access this user with oracle user called RAMREAD as alias having read only privilege. I need not mention the Adminitrator/full privilege user RAMFULL to others during the accessing/using the objects in RAMFULL.
I have created a user/Schema with name RAMFULL
I am using this user/schema with same username for all CRUD operations.
The problem is I have to give this schema to my development center to analyze an issue. but I do not want to give them this db as it is. Since it has all the privileges and it can be tampered or experimented by them.
NOW, I am looking for a solution to create another user which will have only read only privileges and the moment he logs into that account/schema, a person should feel like working on Original schema except the privileges.
I have seen many articles and I could able to get creating synonyms or creating role with Ro by assigning to another user. But in all these the problem is when I do select I have to pre-fix the schema name. For example if I need to search for a table I have to give Select count(*) from SCHEMA1.TABLE1;
I want to know if Schema RAMFULL can be access using RAMREAD user with Read Only privileges. I should not give/mention RAMFULL user anywhere while I am working on RAMREAD user. Please help me out.