Create a username with read only access
I have all objects for the project granted to public
and I need to create new username with read only option.
Other than creating a role and revoke all access from public and giving it to role
and give the role to user ,are there any simpler solution????
Because the above need alot of work
1-Create role
2-Grant all object to role
3-Grant the role to requried users
4-revoke public from all usres
then I can create new user with read only access.
I don't feel thats proper solution....
Any Ideas?