Skip to main content

USER MANAGEMENT

A user is also called as schema/owner

User can able to connect to database through the ‘custom schema’

All data base objects like views, indexes, tables, etc,… can be created under a schema

Customers can be able to connect to the database through the schema/ owner

 

How to create a user?

Create user username identified by password

 

How to lock a user?

Alter user username account lock

 

How to unlock a user?

Alter user username account unlock

 

We have created user but still its not completed, we should grant permissions to the user

 

Grant connect to username

Grant resource to username

Grant create session to username

Now the permissions was granted now the user is active

To delete any user:   drop user username

To change password to the user

Alter user username  identified by password

 

To check password expires

Dba profile

The password expires in 15 days 30 days 45 days 2/6 months /never

Comments

Post a Comment

Popular posts from this blog

Oracle database single instance architecture

Oracle database single instance architecture  Maine database runs on a single machine we referred to this architecture as the Oracle database single instance architecture this setup involves having one Oracle database instance running on the mission serving its clients   The term Oracle database instance simply refers to the combination of memory structure and database process that collectively represent the database service.  However this Architectire has a significant availability risk.  If anything goes wrong with the mission that database becomes UN available.
Post a Comment
Read more

Table spaces

 Tablespace consists of one or more data files.  A data file belongs to only one tablespace. Segments, Extents, and Blocks • Segments exist within a tablespace • Segments are made up of a collection of extents • An extents is a collection of logically contiguous data blocks - Cannot span multiple data files • Data blocks are mapped to disk blocks SYSTEM and SYSAUX Tablespaces • The SYSTEM and SYSAUX tablespaces are mandatory tablespaces. • They are created at the time of database creation. • They must be online. • The SYSTEM tablespace is used for core functionality (for example, data dictionary tables). • The auxiliary SYSAUX tablespace is used for additional database components.
Post a Comment
Read more