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 USER FZAFAR DEFAULT ROLE ALL;    –Dont forget to enable default role all
  — 2 System Privileges for FZAFAR
  GRANT CREATE SESSION TO FZAFAR;
  GRANT SELECT ANY TABLE TO FZAFAR;
  — 1 Tablespace Quota for FZAFAR
  ALTER USER FZAFAR QUOTA UNLIMITED ON USERS;

 

Creating User in TOAD 

1. User Info
Select User Name Password  Resource Profile(Default)

2. TableSpace
Default TableSpace and Temporary Tablespace

3. ROLE
Select CONNECT, RESOURCE, EXECUTE_CATALOG_ROLE, SELECT_CATALOG_ROLE

4. SYSTEM Privileges
Leave Blank

5. Object Grants
Leave Blank (if user asks for specific grants then check the checkboxes)

6. Quotas
Leave Blank

7. Resource Groups
Leave Blank