Creazione di un utente ORACLE

Tips sugli script per operazioni su DB

Creazione di un utente ORACLE

Messaggioda alesslud » mer mar 12, 2014 11:08 am

CREATE USER YOURUSER
IDENTIFIED BY YOURUSER
DEFAULT TABLESPACE SENATO_DATI
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
ACCOUNT UNLOCK;
-- 3 Roles for YOURUSER
GRANT CONNECT TO YOURUSER;
GRANT RESOURCE TO YOURUSER;
GRANT DBA TO YOURUSER;
ALTER USER YOURUSER DEFAULT ROLE ALL;
-- 21 System Privileges for YOURUSER
GRANT DROP ANY PROCEDURE TO YOURUSER;
GRANT CREATE DATABASE LINK TO YOURUSER;
GRANT CREATE ANY VIEW TO YOURUSER;
GRANT SELECT ANY TABLE TO YOURUSER;
GRANT ALTER ANY TABLE TO YOURUSER;
GRANT UNLIMITED TABLESPACE TO YOURUSER;
GRANT ALTER ANY TRIGGER TO YOURUSER;
GRANT CREATE ANY SEQUENCE TO YOURUSER;
GRANT CREATE MATERIALIZED VIEW TO YOURUSER;
GRANT DROP ANY TRIGGER TO YOURUSER;
GRANT ALTER ANY PROCEDURE TO YOURUSER;
GRANT DROP ANY VIEW TO YOURUSER;
GRANT CREATE ANY TRIGGER TO YOURUSER;
GRANT CREATE ANY PROCEDURE TO YOURUSER;
GRANT CREATE ANY TABLE TO YOURUSER;
GRANT EXECUTE ANY PROCEDURE TO YOURUSER;
GRANT CREATE SEQUENCE TO YOURUSER;
GRANT SELECT ANY DICTIONARY TO YOURUSER;
GRANT DROP ANY SEQUENCE TO YOURUSER;
GRANT CREATE SYNONYM TO YOURUSER;
GRANT DROP ANY TABLE TO YOURUSER;
grant create session to YOURUSER;
alesslud
Site Admin
 
Messaggi: 779
Iscritto il: mer nov 08, 2006 8:09 am

Torna a SQL

Chi c’è in linea

Visitano il forum: Nessuno e 0 ospiti

cron