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;