User management role management    

Whenever we are going to create any user we should follow the checklist:

  1. identify the tablespace in which users need to store the object.
  2. Plan for quotas for each tablespace.
  3. Assign a default tablespace and temporary tablespace to the user.
  4. Assign proper me sources [profiles] to the user.

Inclined to build a profession as Oracle DBA Training? Then here is the blog post on, explore Oracle DBA Training

After creating the user by following the above 4 steps, the grant required privileges (or) roles 9set of privileges to the user

Quotes Profiles

  • Table space quotas control the amount of physical storage assigned to the user.
  • A profile is a named set of passwords & resource limits. Generally, this profile contains  

  1. Password again & expiration
  2. Account locking should set in the parameter file Idle time2 resource_limit=TRUE
  3. Cpu time
  4. Connect time
  5. Concurrent session

  Profile Management  

”default” is the default profile from the pupbld. SQL script.  

Advantages of profiles:

  1. Ensures that the users logoff their sessions when they have left their sessions idle for some time.
  2. Enables similar resource limits for a group of users
  3. Easily assign resource limit to the users and control of passwords

  privileges

Privilege is a permission to perform transactions against the database   Privileges Types   Privileges            

For an in-depth knowledge, click on below