Галактика в вопросах и ответах

Код: Выделить всё

DROP USER GAL810#ATLANTIS CASCADE;

CREATE USER GAL810#ATLANTIS
  IDENTIFIED BY VALUES '5A784F882B01864B'
  DEFAULT TABLESPACE USERS
  TEMPORARY TABLESPACE TEMP
  PROFILE DEFAULT
  ACCOUNT UNLOCK;
  -- 2 Roles for GAL810#ATLANTIS 
  GRANT DBA TO GAL810#ATLANTIS;
  GRANT GAL810#RBL TO GAL810#ATLANTIS;
  ALTER USER GAL810#ATLANTIS DEFAULT ROLE DBA;
  -- 2 System Privileges for GAL810#ATLANTIS 
  GRANT UNLIMITED TABLESPACE TO GAL810#ATLANTIS;
  GRANT CREATE SESSION TO GAL810#ATLANTIS;
  -- 3 Object Privileges for GAL810#ATLANTIS 
    GRANT SELECT ON GAL810.ABONENTS TO GAL810#ATLANTIS;
    GRANT SELECT ON GAL810.X$FILES TO GAL810#ATLANTIS;
    GRANT SELECT ON GAL810.X$JOURNALCONFIG TO GAL810#ATLANTIS;