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

Advertisements