1. The Oracle installation after the completion of the user name and password

Sys/change_on_install

The system/manager

Scott/tiger

Sysman/oem_temp

Internal/oracle

2. Modify the user password

SQL> Conn sys/change_on_install as sysdba

Connected.

SQL> Alter user sys identified by * * * * * *.

The User altered.

(3) for the user to unlock

SQL> Conn Scott/tiger

ERROR:

ORA - 28000: the account is locked

Warning: You are no longer connected to ORACLE.

SQL> Conn sys/change_on_install as sysdba

Connected.

SQL> The alter user Scott account unlock;

The User altered.

Lock the user:

SQL> The alter user Scott account lock;

4. To see all users:

Select * from dba_users;

Select * from all_users;

Select * from user_users;

5. Check the user or a role system permissions:

Select * from dba_sys_privs;

Select * from user_sys_privs;

6. Check the user object permissions:

Select * from dba_tab_privs;

Select * from all_tab_privs;

Select * from user_tab_privs;

7.. View all roles:

Select * from dba_roles;

8. To view the role of the user or a role have:

Select * from dba_role_privs;

Select * from user_role_privs;



Create user
9.
SQL> The create user Kevin identified by password

2 the default in tablespace users

3 temporary in tablespace temp

4 10 m quota on the users;

User created.

SQL> Conn Kevin/password

ERROR:

ORA - 01045: user KEVIN lacks, the CREATE SESSION privilege; Logon denied

SQL> Grant create session to Kevin;//authorized users can connect to the database

Grant succeeded.



10. Authorized users connect and resource roles

SQL> Grant connect to Kevin;

Grant succeeded.

SQL> Grant the resource to Kevin;

Grant succeeded.

SQL> Grant connect, the resource to Kevin;

Grant succeeded.



11. Check the connect and resource permissions

SQL> Select * from dba_sys_privs where grantee='CONNECT';

GRANTEE PRIVILEGE ADM

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

CONNECT the ALTER SESSION NO

CONNECT the CREATE CLUSTER NO

CONNECT the CREATE DATABASE LINK NO

CONNECT the CREATE SEQUENCE NO

CONNECT the CREATE SESSION NO

CONNECT the CREATE SYNONYM NO

CONNECT the CREATE TABLE NO

CONNECT the CREATE VIEW NO

8 rows selected.



SQL> Select * from dba_sys_privs where grantee='RESOURCE';

GRANTEE PRIVILEGE ADM

-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

The RESOURCE CREATE TRIGGER NO

The RESOURCE the CREATE SEQUENCE NO

The RESOURCE the CREATE TYPE NO

The RESOURCE CREATE PROCEDURE NO

The RESOURCE the CREATE CLUSTER NO

The RESOURCE CREATE OPERATOR NO

The RESOURCE CREATE INDEXTYPE NO

The RESOURCE CREATE TABLE NO

8 rows selected.



CONNECT role: - was awarded the right to the end user's typical, the most basic

ALTER SESSION - modify SESSION

The CREATE CLUSTER - based clustering

The CREATE DATABASE LINK, establish a DATABASE LINK

The CREATE SEQUENCE in order to build a SEQUENCE

The CREATE SESSION - establish SESSION

CREATE SYNONYM - synonyms

The CREATE VIEW - based VIEW



The RESOURCE role: - is awarded to the developer

The CREATE CLUSTER - based clustering


CREATE PROCEDURE, set up process
The CREATE SEQUENCE in order to build a SEQUENCE

The CREATE TABLE - built TABLE

CREATE the TRIGGER, set up the TRIGGER

The CREATE TYPE - build TYPE

The CREATE INDEXTYPE - index type

The CREATE OPERATOR - based OPERATOR



12. Authorized users access to the operation of the table

SQL> Grant alter any table to Kevin.//Kevin authorized users can access any table

Grant succeeded.

SQL> Grant alter, insert, update on Scott. The emp to Kevin;//authorized user Kevin modification, insert, update table emp permissions



SQL> nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull