DROP USER ora1 CASCADE;
CREATE USER ora1
IDENTIFIED BY ora1
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
ACCOUNT UNLOCK;
-- 2 Roles for ora1
GRANT RESOURCE TO ora1;
GRANT SELECT_CATALOG_ROLE TO ora1;
ALTER USER ora1 DEFAULT ROLE ALL;
-- 7 System Privileges for ora1
GRANT ALTER SESSION TO ora1;
GRANT CREATE DATABASE LINK TO ora1;
GRANT CREATE SEQUENCE TO ora1;
GRANT CREATE SESSION TO ora1;
GRANT CREATE SYNONYM TO ora1;
GRANT CREATE VIEW TO ora1;
GRANT UNLIMITED TABLESPACE TO ora1;
-- 1 Object Privilege for ora1
GRANT EXECUTE ON SYS.DBMS_STATS TO ora1;
------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment