Oracle Database

--
-- Granting Permissions to SYS Objects in AWS RDS
--
-- On AWS RDS you do not have access to the server or to a proper SYSDBA account.  
-- As a result you are defendant on lots of AWS RDS packages.
-- Or in some instances, you need to find new ways of achieving the same thing
--
 
begin
    rdsadmin.rdsadmin_util.grant_sys_object(
        p_obj_name  => 'V_$SESSION',
        p_grantee   => 'USER1',
        p_privilege => 'SELECT');
end;
/

--
-- Granting Permissions to SYS Objects in AWS RDS
--
-- On AWS RDS you do not have access to the server or to a proper SYSDBA account.  
-- As a result you are defendant on lots of AWS RDS packages.
-- Or in some instances, you need to find new ways of achieving the same thing
--
 
begin
    rdsadmin.rdsadmin_util.grant_sys_object(
        p_obj_name     => 'V_$SESSION',
        p_grantee      => 'USER1',
        p_privilege    => 'SELECT',
        p_grant_option => true);
end;
/