User Management Roles in Oracle DBA

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

• 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 time resource_limit=TRUE
3. Cpu time
4. Connect time
5. Concurrent session

”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                

For an in-depth knowledge, click on below

• Introduction to Oracle 10g DBA