CREATE USER DEV IDENTIFIED BY DEVPASS
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
QUOTA 1000M ON USERS
если получили ошибку вида ORA-65096: invalid common user or role name in oracle.
надо выполнить
alter session set "_ORACLE_SCRIPT"=true;
GRANT CREATE SESSION TO DEV
GRANT CREATE TABLE TO DEV
GRANT CREATE PROCEDURE TO DEV
GRANT CREATE TRIGGER TO DEV
GRANT CREATE VIEW TO DEV
GRANT CREATE SEQUENCE TO DEV
GRANT ALTER ANY TABLE TO DEV
GRANT ALTER ANY PROCEDURE TO DEV
GRANT ALTER ANY TRIGGER TO DEV
GRANT ALTER PROFILE TO DEV
GRANT DELETE ANY TABLE TO DEV
GRANT DROP ANY TABLE TO DEV
GRANT DROP ANY PROCEDURE TO DEV
GRANT DROP ANY TRIGGER TO DEV
GRANT DROP ANY VIEW TO DEV
GRANT DROP PROFILE TO DEV
можно изменять пользователя/схему
ALTER USER DEV IDENTIFIED BY NEWPASSWD;
ALTER USER DEV QUOTA UNLIMITED ON USERS;
Комментариев нет:
Отправить комментарий