ORACLE RDS granting select privileges to users.
On the Oracle RDS service in AWS you have no real SYS/SYSDBA account or physical machine. So how do you grant select on SYS objects? AWS have the RDSADMIN account with some useful packages and I have used one of the procedures in RDSADMIN_UTIL to do the job. -- Granting Permissions to SYS Objects in AWS RDS -- In RDS you do not have access to the server or to a proper SYSDBA account. -- begin rdsadmin . rdsadmin_util . grant_sys_object ( p_obj_name => ' V_$SESSION ' , p_grantee => 'DASHVIEW ' , p_privilege => ' SELECT ' ) ; end ; /