i have to grant select access for user on all tables in a application schema. i need suggestion while creating role.
here is my script :
select 'grant select on '||owner||'.'||table_name||' to sel_role;' from dba_tables where owner='APPUSER';
Here are my considerations.
i have to provide only read only access on application tables.
what are the system privileges i need to grant to the users?
object privileges (i am creating role on application objects) i can assign the role to user.
do i need to give execute access on function/procedures/packages to the user?
Anything over that is just a bonus.