User Management Roles in Oracle DBA

29 September, 2020


Related Blogs


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


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

For an in-depth knowledge, click on below

About Author


Author Bio

TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills .