37 lines
1.1 KiB
MySQL
37 lines
1.1 KiB
MySQL
|
--DROP USER SEQUELIZE CASCADE;
|
||
|
|
|
||
|
|
CREATE USER SEQUELIZE
|
||
|
|
IDENTIFIED BY test
|
||
|
|
DEFAULT TABLESPACE SYSAUX
|
||
|
|
TEMPORARY TABLESPACE TEMP
|
||
|
|
PROFILE DEFAULT
|
||
|
|
ACCOUNT UNLOCK;
|
||
|
|
-- 2 Roles for SEQUELIZE
|
||
|
|
GRANT CONNECT TO SEQUELIZE;
|
||
|
|
GRANT AUTHENTICATEDUSER TO SEQUELIZE;
|
||
|
|
ALTER USER SEQUELIZE DEFAULT ROLE NONE;
|
||
|
|
-- 18 System Privileges for SEQUELIZE
|
||
|
|
GRANT CREATE ANY TYPE TO SEQUELIZE;
|
||
|
|
GRANT CREATE ANY TRIGGER TO SEQUELIZE;
|
||
|
|
GRANT CREATE VIEW TO SEQUELIZE;
|
||
|
|
GRANT CREATE SYNONYM TO SEQUELIZE;
|
||
|
|
GRANT CREATE TABLESPACE TO SEQUELIZE;
|
||
|
|
GRANT CREATE ANY INDEXTYPE TO SEQUELIZE;
|
||
|
|
GRANT CREATE ANY SEQUENCE TO SEQUELIZE;
|
||
|
|
GRANT CREATE ANY MATERIALIZED VIEW TO SEQUELIZE;
|
||
|
|
GRANT CREATE TYPE TO SEQUELIZE;
|
||
|
|
GRANT CREATE SEQUENCE TO SEQUELIZE;
|
||
|
|
GRANT CREATE ANY INDEX TO SEQUELIZE;
|
||
|
|
GRANT CREATE ANY TABLE TO SEQUELIZE;
|
||
|
|
GRANT CREATE TABLE TO SEQUELIZE;
|
||
|
|
GRANT CREATE SESSION TO SEQUELIZE;
|
||
|
|
GRANT CREATE TRIGGER TO SEQUELIZE;
|
||
|
|
GRANT CREATE ANY PROCEDURE TO SEQUELIZE;
|
||
|
|
GRANT CREATE ANY VIEW TO SEQUELIZE;
|
||
|
|
GRANT CREATE ANY SYNONYM TO SEQUELIZE;
|
||
|
|
-- 1 Tablespace Quota for SEQUELIZE
|
||
|
|
ALTER USER SEQUELIZE QUOTA UNLIMITED ON SYSAUX;
|
||
|
|
|
||
|
|
quit;
|
||
|
|
/
|