Oracle General User Related TSQL Scripts Commands

Oracle General User Related TSQL Scripts Commands.sql

-- 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;