-- USER SQL CREATE USER user_name IDENTIFIED BY password ; -- ROLES GRANT "GATHER_SYSTEM_STATISTICS" TO user_name WITH ADMIN OPTION; GRANT "LOGSTDBY_ADMINISTRATOR" TO user_name WITH ADMIN OPTION; GRANT "OEM_ADVISOR" TO user_name WITH ADMIN OPTION; GRANT "DBA" TO user_name WITH ADMIN OPTION; GRANT "IMP_FULL_DATABASE" TO user_name WITH ADMIN OPTION; GRANT "AQ_ADMINISTRATOR_ROLE" TO user_name WITH ADMIN OPTION; GRANT "PLUSTRACE" TO user_name WITH ADMIN OPTION; GRANT "OEM_MONITOR" TO user_name WITH ADMIN OPTION; GRANT "DELETE_CATALOG_ROLE" TO user_name WITH ADMIN OPTION; GRANT "EXP_FULL_DATABASE" TO user_name WITH ADMIN OPTION; GRANT "XDBADMIN" TO user_name WITH ADMIN OPTION; GRANT "RECOVERY_CATALOG_OWNER" TO user_name WITH ADMIN OPTION; GRANT "AQ_USER_ROLE" TO user_name WITH ADMIN OPTION; GRANT "SCHEDULER_ADMIN" TO user_name WITH ADMIN OPTION; GRANT "HS_ADMIN_ROLE" TO user_name WITH ADMIN OPTION; GRANT "XDBWEBSERVICES" TO user_name WITH ADMIN OPTION; GRANT "CTXAPP" TO user_name WITH ADMIN OPTION; GRANT "EXECUTE_CATALOG_ROLE" TO user_name WITH ADMIN OPTION; GRANT "AUTHENTICATEDUSER" TO user_name WITH ADMIN OPTION; GRANT "RESOURCE" TO user_name WITH ADMIN OPTION; GRANT "CONNECT" TO user_name WITH ADMIN OPTION; GRANT "SELECT_CATALOG_ROLE" TO user_name WITH ADMIN OPTION; -- SYSTEM PRIVILEGES GRANT "EXECUTE ANY EVALUATION CONTEXT" TO user_name WITH ADMIN OPTION; GRANT "ALTER ANY OPERATOR" TO user_name WITH ADMIN OPTION; GRANT "CREATE INDEXTYPE" TO user_name WITH ADMIN OPTION; GRANT "RESTRICTED SESSION" TO user_name WITH ADMIN OPTION; GRANT "ALTER RESOURCE COST" TO user_name WITH ADMIN OPTION; GRANT "FORCE TRANSACTION" TO user_name WITH ADMIN OPTION; GRANT "DROP ANY PROCEDURE" TO user_name WITH ADMIN OPTION; GRANT "CREATE DIMENSION" TO user_name WITH ADMIN OPTION; GRANT "CREATE ANY INDEXTYPE" TO user_name WITH ADMIN OPTION; GRANT "ALTER DATABASE" TO user_name WITH ADMIN OPTION; GRANT "UPDATE ANY TABLE" TO user_name WITH ADMIN OPTION; GRANT "BACKUP ANY TABLE" TO user_name WITH ADMIN OPTION; GRANT "ALTER ANY OUTLINE" TO user_name WITH ADMIN OPTION; GRANT "CREATE ANY TYPE" TO user_name WITH ADMIN OPTION; GRANT "ALTER ANY TYPE" TO user_name WITH ADMIN OPTION; GRANT "CREATE ANY OPERATOR" TO user_name WITH ADMIN OPTION; GRANT "ALTER SYSTEM" TO user_name WITH ADMIN OPTION; GRANT "UNDER ANY TYPE" TO user_name WITH ADMIN OPTION; GRANT "DROP ANY CONTEXT" TO user_name WITH ADMIN OPTION; GRANT "CREATE ANY JOB" TO user_name WITH ADMIN OPTION; GRANT "DROP ANY SQL PROFILE" TO user_name WITH ADMIN OPTION; GRANT "CREATE DATABASE LINK" TO user_name WITH ADMIN OPTION; GRANT "UNLIMITED TABLESPACE" TO user_name WITH ADMIN OPTION; GRANT "MANAGE SCHEDULER" TO user_name WITH ADMIN OPTION; GRANT "SELECT ANY SEQUENCE" TO user_name WITH ADMIN OPTION; GRANT "EXECUTE ANY OPERATOR" TO user_name WITH ADMIN OPTION; GRANT "DROP ANY VIEW" TO user_name WITH ADMIN OPTION; GRANT "SELECT ANY TRANSACTION" TO user_name WITH ADMIN OPTION; GRANT "IMPORT FULL DATABASE" TO user_name WITH ADMIN OPTION; GRANT "CREATE ANY INDEX" TO user_name WITH ADMIN OPTION; GRANT "DROP ANY INDEX" TO user_name WITH ADMIN OPTION; GRANT "ALTER ANY SQL PROFILE" TO user_name WITH ADMIN OPTION; GRANT "CREATE ANY RULE" TO user_name WITH ADMIN OPTION; GRANT "CREATE ANY CONTEXT" TO user_name WITH ADMIN OPTION; GRANT "CREATE ANY PROCEDURE" TO user_name WITH ADMIN OPTION; GRANT "ALTER ANY INDEX" TO user_name WITH ADMIN OPTION; GRANT "EXECUTE ANY INDEXTYPE" TO user_name WITH ADMIN OPTION; GRANT "CREATE ANY SQL PROFILE" TO user_name WITH ADMIN OPTION; GRANT "ON COMMIT REFRESH" TO user_name WITH ADMIN OPTION; GRANT "MANAGE TABLESPACE" TO user_name WITH ADMIN OPTION; GRANT "CREATE ANY SEQUENCE" TO user_name WITH ADMIN OPTION; GRANT "EXECUTE ANY LIBRARY" TO user_name WITH ADMIN OPTION; GRANT "CREATE TABLE" TO user_name WITH ADMIN OPTION; GRANT "CREATE CLUSTER" TO user_name WITH ADMIN OPTION; GRANT "EXECUTE ANY PROCEDURE" TO user_name WITH ADMIN OPTION; GRANT "ALTER ANY RULE" TO user_name WITH ADMIN OPTION; GRANT "ADMINISTER RESOURCE MANAGER" TO user_name WITH ADMIN OPTION; GRANT "EXEMPT IDENTITY POLICY" TO user_name WITH ADMIN OPTION; GRANT "ENQUEUE ANY QUEUE" TO user_name WITH ADMIN OPTION; GRANT "DROP TABLESPACE" TO user_name WITH ADMIN OPTION; GRANT "COMMENT ANY TABLE" TO user_name WITH ADMIN OPTION; GRANT "BECOME USER" TO user_name WITH ADMIN OPTION; GRANT "DROP ROLLBACK SEGMENT" TO user_name WITH ADMIN OPTION; GRANT "DROP ANY TYPE" TO user_name WITH ADMIN OPTION; GRANT "INSERT ANY TABLE" TO user_name WITH ADMIN OPTION; GRANT "EXECUTE ANY PROGRAM" TO user_name WITH ADMIN OPTION; GRANT "ADVISOR" TO user_name WITH ADMIN OPTION; GRANT "CREATE PROFILE" TO user_name WITH ADMIN OPTION; GRANT "UNDER ANY VIEW" TO user_name WITH ADMIN OPTION; GRANT "ALTER ANY INDEXTYPE" TO user_name WITH ADMIN OPTION; GRANT "DROP ANY SYNONYM" TO user_name WITH ADMIN OPTION; GRANT "AUDIT SYSTEM" TO user_name WITH ADMIN OPTION; GRANT "DROP ANY LIBRARY" TO user_name WITH ADMIN OPTION; GRANT "AUDIT ANY" TO user_name WITH ADMIN OPTION; GRANT "CREATE ANY EVALUATION CONTEXT" TO user_name WITH ADMIN OPTION; GRANT "ADMINISTER SQL TUNING SET" TO user_name WITH ADMIN OPTION; GRANT "ALTER ANY EVALUATION CONTEXT" TO user_name WITH ADMIN OPTION; GRANT "ADMINISTER DATABASE TRIGGER" TO user_name WITH ADMIN OPTION; GRANT "CREATE TRIGGER" TO user_name WITH ADMIN OPTION; GRANT "FORCE ANY TRANSACTION" TO user_name WITH ADMIN OPTION; GRANT "ALTER ANY ROLE" TO user_name WITH ADMIN OPTION; GRANT "DELETE ANY TABLE" TO user_name WITH ADMIN OPTION; GRANT "ANALYZE ANY DICTIONARY" TO user_name WITH ADMIN OPTION; GRANT "SELECT ANY DICTIONARY" TO user_name WITH ADMIN OPTION; GRANT "CREATE USER" TO user_name WITH ADMIN OPTION; GRANT "ANALYZE ANY" TO user_name WITH ADMIN OPTION; GRANT "EXECUTE ANY TYPE" TO user_name WITH ADMIN OPTION; GRANT "EXECUTE ANY CLASS" TO user_name WITH ADMIN OPTION; GRANT "EXECUTE ANY RULE" TO user_name WITH ADMIN OPTION; GRANT "MERGE ANY VIEW" TO user_name WITH ADMIN OPTION; GRANT "CREATE EXTERNAL JOB" TO user_name WITH ADMIN OPTION; GRANT "CHANGE NOTIFICATION" TO user_name WITH ADMIN OPTION; GRANT "EXECUTE ANY RULE SET" TO user_name WITH ADMIN OPTION; GRANT "ALTER ANY DIMENSION" TO user_name WITH ADMIN OPTION; GRANT "CREATE ROLE" TO user_name WITH ADMIN OPTION; GRANT "DROP ANY OPERATOR" TO user_name WITH ADMIN OPTION; GRANT "DROP ANY CLUSTER" TO user_name WITH ADMIN OPTION; GRANT "ALTER ANY TABLE" TO user_name WITH ADMIN OPTION; GRANT "DEQUEUE ANY QUEUE" TO user_name WITH ADMIN OPTION; GRANT "ADMINISTER ANY SQL TUNING SET" TO user_name WITH ADMIN OPTION; GRANT "CREATE RULE" TO user_name WITH ADMIN OPTION; GRANT "DROP ANY DIRECTORY" TO user_name WITH ADMIN OPTION; GRANT "DROP ANY SEQUENCE" TO user_name WITH ADMIN OPTION; GRANT "DROP ANY DIMENSION" TO user_name WITH ADMIN OPTION; GRANT "CREATE SYNONYM" TO user_name WITH ADMIN OPTION; GRANT "CREATE ANY LIBRARY" TO user_name WITH ADMIN OPTION; GRANT "DROP ANY RULE" TO user_name WITH ADMIN OPTION; GRANT "CREATE LIBRARY" TO user_name WITH ADMIN OPTION; GRANT "EXPORT FULL DATABASE" TO user_name WITH ADMIN OPTION; GRANT "CREATE ANY OUTLINE" TO user_name WITH ADMIN OPTION; GRANT "CREATE SESSION" TO user_name WITH ADMIN OPTION; GRANT "LOCK ANY TABLE" TO user_name WITH ADMIN OPTION; GRANT "ALTER ANY PROCEDURE" TO user_name WITH ADMIN OPTION; GRANT "READ ANY FILE GROUP" TO user_name WITH ADMIN OPTION; GRANT "SELECT ANY TABLE" TO user_name WITH ADMIN OPTION; GRANT "ALTER SESSION" TO user_name WITH ADMIN OPTION; GRANT "CREATE MATERIALIZED VIEW" TO user_name WITH ADMIN OPTION; GRANT "CREATE PUBLIC SYNONYM" TO user_name WITH ADMIN OPTION; GRANT "CREATE ANY TRIGGER" TO user_name WITH ADMIN OPTION; GRANT "GRANT "ANY OBJECT PRIVILEGE" TO user_name WITH ADMIN OPTION; GRANT "DROP ANY OUTLINE" TO user_name WITH ADMIN OPTION; GRANT "ALTER ANY CLUSTER" TO user_name WITH ADMIN OPTION; GRANT "CREATE TABLESPACE" TO user_name WITH ADMIN OPTION; GRANT "ALTER ANY RULE SET" TO user_name WITH ADMIN OPTION; GRANT "ALTER ANY MATERIALIZED VIEW" TO user_name WITH ADMIN OPTION; GRANT "QUERY REWRITE" TO user_name WITH ADMIN OPTION; GRANT "GLOBAL QUERY REWRITE" TO user_name WITH ADMIN OPTION; GRANT "CREATE ROLLBACK SEGMENT" TO user_name WITH ADMIN OPTION; GRANT "DROP ANY INDEXTYPE" TO user_name WITH ADMIN OPTION; GRANT "DROP USER" TO user_name WITH ADMIN OPTION; GRANT "DROP ANY TABLE" TO user_name WITH ADMIN OPTION; GRANT "CREATE JOB" TO user_name WITH ADMIN OPTION; GRANT "DROP ANY EVALUATION CONTEXT" TO user_name WITH ADMIN OPTION; GRANT "CREATE ANY SYNONYM" TO user_name WITH ADMIN OPTION; GRANT "DROP PROFILE" TO user_name WITH ADMIN OPTION; GRANT "DROP PUBLIC SYNONYM" TO user_name WITH ADMIN OPTION; GRANT "FLASHBACK ANY TABLE" TO user_name WITH ADMIN OPTION; GRANT "CREATE SEQUENCE" TO user_name WITH ADMIN OPTION; GRANT "ALTER TABLESPACE" TO user_name WITH ADMIN OPTION; GRANT "CREATE OPERATOR" TO user_name WITH ADMIN OPTION; GRANT "EXEMPT ACCESS POLICY" TO user_name WITH ADMIN OPTION; GRANT "CREATE ANY DIRECTORY" TO user_name WITH ADMIN OPTION; GRANT "ALTER ROLLBACK SEGMENT" TO user_name WITH ADMIN OPTION; GRANT "CREATE ANY DIMENSION" TO user_name WITH ADMIN OPTION; GRANT "MANAGE FILE GROUP" TO user_name WITH ADMIN OPTION; GRANT "GRANT "ANY PRIVILEGE" TO user_name WITH ADMIN OPTION; GRANT "DROP ANY RULE SET" TO user_name WITH ADMIN OPTION; GRANT "CREATE ANY VIEW" TO user_name WITH ADMIN OPTION; GRANT "CREATE PUBLIC DATABASE LINK" TO user_name WITH ADMIN OPTION; GRANT "CREATE RULE SET" TO user_name WITH ADMIN OPTION; GRANT "DROP ANY ROLE" TO user_name WITH ADMIN OPTION; GRANT "CREATE ANY MATERIALIZED VIEW" TO user_name WITH ADMIN OPTION; GRANT "CREATE ANY CLUSTER" TO user_name WITH ADMIN OPTION; GRANT "CREATE TYPE" TO user_name WITH ADMIN OPTION; GRANT "DROP ANY MATERIALIZED VIEW" TO user_name WITH ADMIN OPTION; GRANT "CREATE VIEW" TO user_name WITH ADMIN OPTION; GRANT "UNDER ANY TABLE" TO user_name WITH ADMIN OPTION; GRANT "MANAGE ANY FILE GROUP" TO user_name WITH ADMIN OPTION; GRANT "ALTER ANY TRIGGER" TO user_name WITH ADMIN OPTION; GRANT "CREATE ANY RULE SET" TO user_name WITH ADMIN OPTION; GRANT "DEBUG ANY PROCEDURE" TO user_name WITH ADMIN OPTION; GRANT "GRANT "ANY ROLE" TO user_name WITH ADMIN OPTION; GRANT "DROP ANY TRIGGER" TO user_name WITH ADMIN OPTION; GRANT "ALTER USER" TO user_name WITH ADMIN OPTION; GRANT "ALTER PROFILE" TO user_name WITH ADMIN OPTION; GRANT "DROP PUBLIC DATABASE LINK" TO user_name WITH ADMIN OPTION; GRANT "MANAGE ANY QUEUE" TO user_name WITH ADMIN OPTION; GRANT "CREATE PROCEDURE" TO user_name WITH ADMIN OPTION; GRANT "SYSOPER" TO user_name WITH ADMIN OPTION; GRANT "CREATE ANY TABLE" TO user_name WITH ADMIN OPTION; GRANT "RESUMABLE" TO user_name WITH ADMIN OPTION; GRANT "CREATE EVALUATION CONTEXT" TO user_name WITH ADMIN OPTION; GRANT "SYSDBA" TO user_name WITH ADMIN OPTION; GRANT "ALTER ANY LIBRARY" TO user_name WITH ADMIN OPTION; GRANT "ALTER ANY SEQUENCE" TO user_name WITH ADMIN OPTION; GRANT "DEBUG CONNECT SESSION" TO user_name WITH ADMIN OPTION; -- QUOTAS
フム……
