Oracle Database - User (Account/Client)

Card Puncher Data Processing

About

A user is an entity that can be authenticated. A user can be a person or a software entity, such as a Java client. Each user is given a unique identity within a security realm. For efficient security management, Oracle recommends adding users to groups. A group is a collection of users who usually have something in common, such as working in the same department in a company.

You assign a profile to a user in order to control application parameters such as password, session behaviours.

Management

Create

The minimal statement is:

create user user identified by password;
-- Example
create user nico identified by nico quota unlimited ON users;
 
-- Followed generally by
GRANT CONNECT, resource TO nico;

User and password must follow the oracle naming convention and must be in ASCII

The default value for the tablespaces will be:

select default_tablespace, TEMPORARY_TABLESPACE from dba_users where username = 'NICO';
DEFAULT_TABLESPACE             TEMPORARY_TABLESPACE
------------------------------ ------------------------------
USERS                          TEMP

Lock and Unlock

ALTER USER SH ACCOUNT UNLOCK;
ALTER USER SH ACCOUNT LOCK;

Password Modification

alter user "gerard" identified by "newPwd";

Password Policy

How to disable the default password policy change of 180 days.

ALTER PROFILE "DEFAULT" LIMIT PASSWORD_VERIFY_FUNCTION NULL;
alter user USERNAME identified by PWD account unlock;

Documentation / Reference





Discover More
Card Puncher Data Processing
Oracle Database - CURRENT_USER, SESSION_USER

When a session starts, CURRENT_USER has the same value as SESSION_USER and give the user id To get the current value of: CURRENT_SCHEMA, CURRENT_USER, or SESSION_USER use the userenv CONTEXT...
Card Puncher Data Processing
Oracle Database - Export Utility (exp)

Client Export utility. See The Export utility supports four modes of operation: Full: Exports a full database. Only users with the EXP_FULL_DATABASE role can use this mode. The FULL parameter...
Card Puncher Data Processing
Oracle Database - Non-schema Object

user role public synonym
Card Puncher Data Processing
Oracle Database - Objects

Database object. Each database object is considered to either be: a schema object (ie owned by a user) or a “non-schema object”. See for plsql object type: Object in different namespace are...
Card Puncher Data Processing
Oracle Database - Schema

A schema is a logical collection of schema objects all of which are owned by a user.
Card Puncher Data Processing
Oracle Database - User Profile

A profile is a collection of parameters that sets limits on database resources. When you change the profile to a user, you assign a profile but you apply also a set of parameters. If you assign the profile...



Share this page:
Follow us:
Task Runner