Thank up Amazon RDS team for giving us DBA's a little more power with 11.2.0.2v3 version.
Execute privileges to a number of DBMS packages including DBMS_CRYPTO, DBMS_ALERT, DBMS_LOCK and DBMS_PIPE are now available.
Privileges to grant DBA, CONNECT and RESOURCE roles to other users are also available.
You can use the CTXAPP (Oracle Text) role and grant it to other users.
The system privileges “RESTRICTED SESSION” and “GRANT ANY OBJECT".
For the full announcement forum: https://forums.aws.amazon.com/ann.jspa?annID=1186
simply superb,mind blowing, i will share your blog to my friends also
ReplyDeleteAWS Online Training