Archive for the ‘Privileges’ Category

Standard User Creation Procedure

CREATE USER FZAFAR   IDENTIFIED BY VALUES ’2BC657B017E6006B’   DEFAULT TABLESPACE USERS   TEMPORARY TABLESPACE TEMP   PROFILE DEFAULT   ACCOUNT UNLOCK;   — 5 Roles for ITSM   GRANT SELECT_CATALOG_ROLE TO FZAFAR;   GRANT EXECUTE_CATALOG_ROLE TO FZAFAR;   GRANT DELETE_CATALOG_ROLE TO FZAFAR;   GRANT RESOURCE TO FZAFAR;   GRANT CONNECT TO FZAFAR;   ALTER [...]

Continue reading »

Follow

Get every new post delivered to your Inbox.