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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: