User Management in Oracle 12c

Screenshot_44


Profile Management

Screenshot_46

”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 group of users
  3. Easily assign resource limit to the users and control of passwords

Screenshot_47
Privilege is a permission ot perform transactions against the database

Screenshot_48

Screenshot_49

Comments

Popular posts from this blog

Step by Step: How to troubleshoot a slow running query in Oracle

Register Archive log file manually in standby Database

How to check UNDO tablespace usage and who is using more undo