Instantly share code, notes, and snippets.
Created
June 6, 2020 19:13
-
Star
0
(0)
You must be signed in to star a gist -
Fork
0
(0)
You must be signed in to fork a gist
-
-
Save JavierCanon/3a20ae30acdbfbe973d99463f3f271b9 to your computer and use it in GitHub Desktop.
Oracle General User Related TSQL Scripts Commands
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- CHANGE PASSWORD | |
| ALTER USER "TSFOODS" IDENTIFIED BY "TSFOODS"; | |
| -- USER SQL | |
| CREATE USER "TSFOODS" IDENTIFIED BY "TSFOODS/*-" | |
| DEFAULT TABLESPACE "USERS" | |
| TEMPORARY TABLESPACE "TEMP"; | |
| -- QUOTAS | |
| ALTER USER "TSFOODS" QUOTA UNLIMITED ON "SYSTEM"; | |
| ALTER USER "TSFOODS" QUOTA UNLIMITED ON "SYSAUX"; | |
| ALTER USER "TSFOODS" QUOTA UNLIMITED ON "USERS"; | |
| -- ROLES | |
| GRANT "DBA" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "DV_MONITOR" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "CTXAPP" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "DV_AUDIT_CLEANUP" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "EM_EXPRESS_ALL" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "WM_ADMIN_ROLE" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "OLAP_USER" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "OLAP_XS_ADMIN" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "DV_SECANALYST" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "RECOVERY_CATALOG_OWNER_VPD" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "XS_CACHE_ADMIN" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "GDS_CATALOG_SELECT" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "SCHEDULER_ADMIN" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "PROVISIONER" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "AUDIT_ADMIN" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "XDB_WEBSERVICES_OVER_HTTP" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "DV_REALM_RESOURCE" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "AQ_ADMINISTRATOR_ROLE" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "SYSUMF_ROLE" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "APPLICATION_TRACE_VIEWER" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "XDB_WEBSERVICES" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "DV_PUBLIC" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "LBAC_DBA" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "OPTIMIZER_PROCESSING_RATE" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "RECOVERY_CATALOG_USER" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "DV_DATAPUMP_NETWORK_LINK" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "GSMUSER_ROLE" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "GATHER_SYSTEM_STATISTICS" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "LOGSTDBY_ADMINISTRATOR" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "DBJAVASCRIPT" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "GSM_POOLADMIN_ROLE" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "DV_ADMIN" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "DV_POLICY_OWNER" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "HS_ADMIN_ROLE" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "XS_SESSION_ADMIN" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "DV_GOLDENGATE_ADMIN" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "IMP_FULL_DATABASE" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "DV_XSTREAM_ADMIN" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "DV_PATCH_ADMIN" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "GGSYS_ROLE" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "DATAPUMP_EXP_FULL_DATABASE" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "EJBCLIENT" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "HS_ADMIN_EXECUTE_ROLE" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "JMXSERVER" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "OLAP_DBA" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "ADM_PARALLEL_EXECUTE_TASK" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "JAVAIDPRIV" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "SELECT_CATALOG_ROLE" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "JAVADEBUGPRIV" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "CONNECT" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "DATAPUMP_IMP_FULL_DATABASE" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "SODA_APP" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "OEM_MONITOR" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "GSMADMIN_ROLE" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "AQ_USER_ROLE" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "JAVAUSERPRIV" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "XDB_SET_INVOKER" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "RECOVERY_CATALOG_OWNER" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "JAVA_ADMIN" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "DBFS_ROLE" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "PDB_DBA" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "RDFCTX_ADMIN" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "DV_GOLDENGATE_REDO_ACCESS" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "CDB_DBA" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "JAVASYSPRIV" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "HS_ADMIN_SELECT_ROLE" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "AUDIT_VIEWER" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "RESOURCE" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "DV_OWNER" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "XDB_WEBSERVICES_WITH_PUBLIC" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "EXECUTE_CATALOG_ROLE" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "DATAPATCH_ROLE" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "DV_ACCTMGR" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "DV_REALM_OWNER" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "EXP_FULL_DATABASE" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "DBMS_MDX_INTERNAL" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "DV_STREAMS_ADMIN" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "XS_NAMESPACE_ADMIN" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "ORDADMIN" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "AUTHENTICATEDUSER" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "CAPTURE_ADMIN" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "OEM_ADVISOR" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "XS_CONNECT" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "XDBADMIN" TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT "EM_EXPRESS_BASIC" TO "TSFOODS" WITH ADMIN OPTION; | |
| -- SYSTEM PRIVILEGES | |
| GRANT CREATE JOB TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT DROP ANY CONTEXT TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT UPDATE ANY CUBE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT ALTER ANY ANALYTIC VIEW TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT DROP ANY TRIGGER TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT DROP ANY SQL TRANSLATION PROFILE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT MANAGE ANY FILE GROUP TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT ALTER PUBLIC DATABASE LINK TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT MANAGE FILE GROUP TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT ALTER ANY INDEX TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT DROP ANY SEQUENCE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT ALTER PROFILE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT INHERIT ANY PRIVILEGES TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT UNDER ANY TABLE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT KEEP SYSGUID TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE ASSEMBLY TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT DROP ANY LIBRARY TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT ALTER ANY EDITION TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE ROLE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE LIBRARY TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT DROP ROLLBACK SEGMENT TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE TRIGGER TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT ALTER ANY PROCEDURE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT ADMINISTER DATABASE TRIGGER TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT DROP ANY MEASURE FOLDER TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE ANY PROCEDURE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT ALTER ANY OUTLINE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE ANY ANALYTIC VIEW TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT EXECUTE ANY INDEXTYPE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT USE ANY JOB RESOURCE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE ANY DIRECTORY TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT ALTER ANY RULE SET TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT USE ANY SQL TRANSLATION PROFILE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT ALTER ANY MINING MODEL TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT DEBUG CONNECT SESSION TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT LOGMINING TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT DROP ANY ATTRIBUTE DIMENSION TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE ANY MINING MODEL TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE LOCKDOWN PROFILE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT ALTER SESSION TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE MATERIALIZED VIEW TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE PLUGGABLE DATABASE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT DROP ANY ANALYTIC VIEW TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT WRITE ANY ANALYTIC VIEW CACHE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT MERGE ANY VIEW TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE ANY INDEX TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT READ ANY ANALYTIC VIEW CACHE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE DIMENSION TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT EXECUTE ANY RULE SET TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE SQL TRANSLATION PROFILE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT ALTER ANY MATERIALIZED VIEW TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT AUDIT SYSTEM TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE OPERATOR TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT MANAGE ANY QUEUE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT ALTER ANY SQL PROFILE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT GRANT ANY OBJECT PRIVILEGE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE INDEXTYPE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT AUDIT ANY TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT INHERIT ANY REMOTE PRIVILEGES TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT SYSKM TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT DEBUG ANY PROCEDURE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE ANY MEASURE FOLDER TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE ANY SEQUENCE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE MEASURE FOLDER TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT UPDATE ANY CUBE BUILD PROCESS TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE VIEW TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT ALTER DATABASE LINK TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT ALTER ANY ASSEMBLY TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT ALTER ANY SQL TRANSLATION PROFILE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE ANY EVALUATION CONTEXT TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT SELECT ANY MINING MODEL TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT SYSRAC TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT DELETE ANY CUBE DIMENSION TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT ALTER ANY TABLE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT ALTER ANY ATTRIBUTE DIMENSION TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE SESSION TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE RULE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT BECOME USER TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT SELECT ANY CUBE BUILD PROCESS TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT SELECT ANY TABLE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT INSERT ANY MEASURE FOLDER TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE ANY SQL PROFILE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT FORCE ANY TRANSACTION TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT DELETE ANY TABLE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT ALTER ANY SEQUENCE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT SELECT ANY CUBE DIMENSION TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE ANY EDITION TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE EXTERNAL JOB TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT EM EXPRESS CONNECT TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT DROP ANY MATERIALIZED VIEW TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE ANY CUBE BUILD PROCESS TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT FLASHBACK ANY TABLE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT DROP ANY RULE SET TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT BACKUP ANY TABLE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT ALTER ANY CUBE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE CREDENTIAL TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE TABLE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT EXECUTE ANY LIBRARY TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT DROP ANY OUTLINE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT EXECUTE ASSEMBLY TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE ANY HIERARCHY TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE ANALYTIC VIEW TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE ANY DIMENSION TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT DROP ANY TABLE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT ADMINISTER KEY MANAGEMENT TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT ALTER ANY CLUSTER TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT EXECUTE ANY CLASS TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT ALTER ANY CUBE BUILD PROCESS TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE ANY CREDENTIAL TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT DROP ANY DIMENSION TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT SYSBACKUP TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE ANY RULE SET TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT SELECT ANY SEQUENCE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT UNDER ANY TYPE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT MANAGE TABLESPACE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT DROP ANY OPERATOR TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE ANY OPERATOR TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT DROP ANY HIERARCHY TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT EXEMPT IDENTITY POLICY TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE TYPE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE TABLESPACE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT SELECT ANY TRANSACTION TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT DELETE ANY MEASURE FOLDER TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE ANY CUBE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT LOCK ANY TABLE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE EVALUATION CONTEXT TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT DROP ANY TYPE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT ADVISOR TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE PUBLIC DATABASE LINK TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT ANALYZE ANY TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE ATTRIBUTE DIMENSION TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT DROP ANY RULE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT INSERT ANY CUBE DIMENSION TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE ROLLBACK SEGMENT TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE ANY JOB TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT ALTER USER TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT QUERY REWRITE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT SELECT ANY DICTIONARY TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE PUBLIC SYNONYM TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT GLOBAL QUERY REWRITE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT ALTER ANY CUBE DIMENSION TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE ANY CUBE DIMENSION TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT DROP ANY CLUSTER TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE ANY RULE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT UPDATE ANY CUBE DIMENSION TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT SYSDBA TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT ADMINISTER RESOURCE MANAGER TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE ANY SYNONYM TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT DROP ANY SYNONYM TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT DROP ANY MINING MODEL TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT EXECUTE ANY PROCEDURE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE SYNONYM TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT SET CONTAINER TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT EXECUTE ANY PROGRAM TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT EXEMPT REDACTION POLICY TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT EXECUTE ANY TYPE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT ON COMMIT REFRESH TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT DEBUG CONNECT ANY TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE SEQUENCE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE HIERARCHY TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT SELECT ANY MEASURE FOLDER TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT COMMENT ANY MINING MODEL TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT ADMINISTER SQL TUNING SET TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT SYSOPER TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE ANY INDEXTYPE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT KEEP DATE TIME TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT DROP ANY INDEX TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT RESTRICTED SESSION TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT SYSDG TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT DEQUEUE ANY QUEUE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT ANALYZE ANY DICTIONARY TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT ALTER ANY INDEXTYPE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT TRANSLATE ANY SQL TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT ADMINISTER ANY SQL TUNING SET TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE USER TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT EXECUTE ANY OPERATOR TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE CUBE BUILD PROCESS TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE PROFILE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT ALTER ANY ROLE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT UPDATE ANY TABLE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT ALTER ANY LIBRARY TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT DROP ANY VIEW TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE ANY CLUSTER TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT EXECUTE ANY RULE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT ALTER TABLESPACE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT UNDER ANY VIEW TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT EXECUTE ANY ASSEMBLY TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT GRANT ANY PRIVILEGE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT ALTER ANY TRIGGER TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE ANY VIEW TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT ALTER LOCKDOWN PROFILE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT EXPORT FULL DATABASE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT ALTER ANY MEASURE FOLDER TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT ALTER ANY EVALUATION CONTEXT TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT TEXT DATASTORE ACCESS TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT FLASHBACK ARCHIVE ADMINISTER TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT IMPORT FULL DATABASE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE ANY OUTLINE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT COMMENT ANY TABLE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT READ ANY TABLE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE DATABASE LINK TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT DROP PUBLIC SYNONYM TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT DROP USER TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CHANGE NOTIFICATION TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE MINING MODEL TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT INSERT ANY TABLE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT DROP LOCKDOWN PROFILE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT DROP PROFILE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE ANY MATERIALIZED VIEW TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE RULE SET TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT EXEMPT ACCESS POLICY TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT MANAGE SCHEDULER TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT READ ANY FILE GROUP TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT FORCE TRANSACTION TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT DROP ANY CUBE BUILD PROCESS TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT ALTER ANY TYPE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT DROP ANY PROCEDURE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE ANY SQL TRANSLATION PROFILE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT DROP PUBLIC DATABASE LINK TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT DROP ANY INDEXTYPE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT DROP ANY SQL PROFILE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT ALTER SYSTEM TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT UNLIMITED TABLESPACE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT DROP ANY ROLE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT ALTER ANY DIMENSION TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT DROP ANY CUBE DIMENSION TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT DROP ANY CUBE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE ANY TRIGGER TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT DROP ANY ASSEMBLY TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE ANY TABLE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT ADMINISTER SQL MANAGEMENT OBJECT TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT DROP ANY DIRECTORY TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT ENQUEUE ANY QUEUE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT DROP ANY EVALUATION CONTEXT TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE ANY ASSEMBLY TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE ANY TYPE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT REDEFINE ANY TABLE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE CLUSTER TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE ANY CONTEXT TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT EXECUTE ANY EVALUATION CONTEXT TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT RESUMABLE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE ANY LIBRARY TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT DROP ANY EDITION TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE PROCEDURE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT ALTER DATABASE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT SELECT ANY CUBE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT GRANT ANY ROLE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT ALTER ANY RULE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE ANY ATTRIBUTE DIMENSION TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE CUBE DIMENSION TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT ALTER ANY OPERATOR TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT CREATE CUBE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT ALTER RESOURCE COST TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT ALTER ANY HIERARCHY TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT DROP TABLESPACE TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT ALTER ROLLBACK SEGMENT TO "TSFOODS" WITH ADMIN OPTION; | |
| GRANT PURGE DBA_RECYCLEBIN TO "TSFOODS" WITH ADMIN OPTION; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment