create role role_d;
grant ALTER ANY OUTLINE to role_d;
grant EXECUTE ANY INDEXTYPE to role_d;
grant UNDER ANY VIEW to role_d;
grant ALTER ANY LIBRARY to role_d;
grant CREATE LIBRARY to role_d;
grant UNDER ANY TYPE to role_d;
grant CREATE ANY DIRECTORY to role_d;
grant DELETE ANY TABLE to role_d;
grant CREATE TABLE to role_d;
grant ADMINISTER ANY SQL TUNING SET to role_d;
grant CREATE ANY EVALUATION CONTEXT to role_d;
grant GRANT ANY OBJECT PRIVILEGE to role_d;
grant ADMINISTER RESOURCE MANAGER to role_d;
grant DEQUEUE ANY QUEUE to role_d;
grant ENQUEUE ANY QUEUE to role_d;
grant CREATE ANY DIMENSION to role_d;
grant CREATE TYPE to role_d;
grant DROP ANY MATERIALIZED VIEW to role_d;
grant DROP ANY TRIGGER to role_d;
grant ALTER ANY PROCEDURE to role_d;
grant DROP ANY ROLE to role_d;
grant CREATE SEQUENCE to role_d;
grant CREATE VIEW to role_d;
grant UPDATE ANY TABLE to role_d;
grant ADMINISTER SQL TUNING SET to role_d;
grant CREATE ANY RULE to role_d;
grant EXPORT FULL DATABASE to role_d;
grant CREATE EVALUATION CONTEXT to role_d;
grant RESUMABLE to role_d;
grant MERGE ANY VIEW to role_d;
grant ADMINISTER DATABASE TRIGGER to role_d;
grant CREATE ANY CONTEXT to role_d;
grant GLOBAL QUERY REWRITE to role_d;
grant CREATE INDEXTYPE to role_d;
grant DROP ANY OPERATOR to role_d;
grant CREATE ANY LIBRARY to role_d;
grant DROP ANY TYPE to role_d;
grant CREATE ANY MATERIALIZED VIEW to role_d;
grant CREATE PROFILE to role_d;
grant CREATE ANY PROCEDURE to role_d;
grant AUDIT ANY to role_d;
grant CREATE ROLE to role_d;
grant DROP PUBLIC DATABASE LINK to role_d;
grant DROP ANY SEQUENCE to role_d;
grant ALTER ANY SEQUENCE to role_d;
grant CREATE PUBLIC SYNONYM to role_d;
grant CREATE ANY SYNONYM to role_d;
grant DROP ANY INDEX to role_d;
grant COMMENT ANY TABLE to role_d;
grant DROP ANY TABLE to role_d;
grant CHANGE NOTIFICATION to role_d;
grant CREATE ANY JOB to role_d;
grant ADVISOR to role_d;
grant ALTER ANY RULE SET to role_d;
grant ALTER ANY EVALUATION CONTEXT to role_d;
grant DROP ANY CONTEXT to role_d;
grant QUERY REWRITE to role_d;
grant CREATE ANY OPERATOR to role_d;
grant ALTER RESOURCE COST to role_d;
grant CREATE TRIGGER to role_d;
grant DROP ANY PROCEDURE to role_d;
grant FORCE ANY TRANSACTION to role_d;
grant CREATE PUBLIC DATABASE LINK to role_d;
grant SELECT ANY SEQUENCE to role_d;
grant CREATE SYNONYM to role_d;
grant BACKUP ANY TABLE to role_d;
grant ALTER ROLLBACK SEGMENT to role_d;
grant CREATE EXTERNAL JOB to role_d;
grant ALTER ANY SQL PROFILE to role_d;
grant DROP ANY DIMENSION to role_d;
grant CREATE OPERATOR to role_d;
grant GRANT ANY PRIVILEGE to role_d;
grant ALTER PROFILE to role_d;
grant CREATE ANY SEQUENCE to role_d;
grant DROP ANY VIEW to role_d;
grant BECOME USER to role_d;
grant MANAGE FILE GROUP to role_d;
grant ANALYZE ANY DICTIONARY to role_d;
grant DEBUG CONNECT SESSION to role_d;
grant SELECT ANY DICTIONARY to role_d;
grant ON COMMIT REFRESH to role_d;
grant CREATE ANY OUTLINE to role_d;
grant MANAGE ANY QUEUE to role_d;
grant UNDER ANY TABLE to role_d;
grant CREATE ANY INDEXTYPE to role_d;
grant EXECUTE ANY LIBRARY to role_d;
grant ALTER ANY MATERIALIZED VIEW to role_d;
grant ANALYZE ANY to role_d;
grant EXECUTE ANY PROCEDURE to role_d;
grant ALTER ANY ROLE to role_d;
grant SELECT ANY TABLE to role_d;
grant ALTER ANY TABLE to role_d;
grant CREATE ANY TABLE to role_d;
grant CREATE SESSION to role_d;
grant READ ANY FILE GROUP to role_d;
grant SELECT ANY TRANSACTION to role_d;
grant CREATE JOB to role_d;
grant IMPORT FULL DATABASE to role_d;
grant EXECUTE ANY RULE SET to role_d;
grant DROP ANY RULE SET to role_d;
grant CREATE RULE SET to role_d;
grant EXECUTE ANY EVALUATION CONTEXT to role_d;
grant FLASHBACK ANY TABLE to role_d;
grant ALTER ANY DIMENSION to role_d;
grant CREATE DIMENSION to role_d;
grant ALTER ANY INDEXTYPE to role_d;
grant EXECUTE ANY OPERATOR to role_d;
grant EXECUTE ANY TYPE to role_d;
grant CREATE ANY TRIGGER to role_d;
grant CREATE PROCEDURE to role_d;
grant FORCE TRANSACTION to role_d;
grant CREATE ANY VIEW to role_d;
grant ALTER ANY INDEX to role_d;
grant CREATE ANY INDEX to role_d;
grant INSERT ANY TABLE to role_d;
grant MANAGE ANY FILE GROUP to role_d;
grant MANAGE SCHEDULER to role_d;
grant EXECUTE ANY CLASS to role_d;
grant EXECUTE ANY PROGRAM to role_d;
grant ALTER ANY RULE to role_d;
grant CREATE ANY RULE SET to role_d;
grant DEBUG ANY PROCEDURE to role_d;
grant DROP ANY INDEXTYPE to role_d;
grant ALTER ANY TYPE to role_d;
grant CREATE ANY TYPE to role_d;
grant CREATE MATERIALIZED VIEW to role_d;
grant DROP PROFILE to role_d;
grant ALTER ANY TRIGGER to role_d;
grant GRANT ANY ROLE to role_d;
grant CREATE DATABASE LINK to role_d;
grant DROP ANY SYNONYM to role_d;
grant MANAGE TABLESPACE to role_d;
grant RESTRICTED SESSION to role_d;
grant connect to role_d;
grant resource to role_d;
grant role_d to AMS_FWZK;
grant unlimited tablespace to AMS_FWZK;
revoke dba from AMS_FWZK;
