A detailed explanation of how to unlock the user in Oracle __oracle

explain how to unlock the user in Oracle

Absrtact: Here we will introduce Oracle's methods of unlocking users, including adding users, empowering, modifying passwords, unlocking, and so on in Oracle.

This article introduces Oracle's approach to unlocking users, hoping that Oracle can unlock users by adding users, empowering, modifying passwords, and unlocking them in Oracle. This article can be helpful to everyone.

Add User: (automatically generate a schema with the same name as the user creates)

CREATEUSER "TESTER" Profile "DEFAULT" identified by"TESTER" DEFAULTTablespace "TESTDATA" TemporaryTablespace "testtemp" account UNLOCK;

Empowering:

(These permissions are the permissions that are used in development and, if the user produces the environment, create the appropriate system permissions for the user)

It is said that the production environment, just connect resource such a role can be.

GRANT"CONNECT" to"TESTER"; GRANT"RESOURCE" to"TESTER"; GRANT"DBA" to"TESTER"; GRANT"Exp_full_database" to"TESTER"; GRANT"Imp_full_database" to"TESTER";

User modifies password, Oracle unlocks to User:

ALTERUSER "SCOTT" identified by"*******" ALTERUSER "SCOTT" account UNLOCK

1. View All Users:

Select* fromDba_user; Select* fromAll_users; Select* fromUser_users;

2. View User system permissions:

Select* fromDba_sys_privs; Select* fromAll_sys_privs; Select* fromUser_sys_privs;

3. View User Object permissions:

Select* fromDba_tab_privs; Select* fromAll_tab_privs; Select* fromUser_tab_privs;

4. View all roles:

Select* fromDba_roles;

5. View the roles that users have:

Select* fromDba_role_privs; Select* fromUser_role_privs;

New User name in Oracle

To connect to an Oracle database:

1, in Oracle Database Assistant to establish their own databases;

2, in Oracle Net8 Easy config to establish a connection with their own database connection, take a service name, IP: for the local IP 127.0.0.1,database SID for you to build

SID of the database, Username: System, Password: Manager or the password you set;

3, in the Sqlplus to connect their own database, the user name is: System, Password: Manager or your own password, Tom: You have just established the service name.

4, display the current connection user: show user;

5, the new user and authorization: Create user Tom identified by password;

Grant Connect,resource to Tom;

6, in Sqlplus with the newly established user: tom/password, connection;

7, the establishment of table space.

Initialization parameter file for database: init+ instance name. ora file, edit the contents of this file, you can change the method used by the database and the allocated resources.

Start Oracle database, run SVRMGR30 in DOS mode, then enter connect internal, password: Oracle, then enter startup.

Table Space creation: Storage Manager

The rollback segment can be established in Storage Manager

Start Oracle Database

Under DOS window, enter SVRMGR30, start Server Manager, enter connect internal, enter password Oracle, enter shutdown, close database, enter startup, start database.

1. Oracle installation After the completion of the initial password?

Internal/oracle Sys/change_on_install System/manager Scott/tiger sysman/oem_temp

Create a table space

CreateTablespace test1 datafile ' d:tabletest1.dbf ' size1M;

Create a user named WJQ whose default tablespace is Test1. In Sql*plus, connect the database with the SYS user, and run the following script.

CreateUser WJQ identified by Password defaultTablespace test1;

Connect Sqlplus with User Wjq

Create a table:

CREATE TABLET1 (empno number (5) PRIMARY KEY, ename VARCHAR2 not NULL, Job VARCHAR2 (Ten), Mgr Number (5), HireDate DATE DEFAULT(sysdate), Sal number (7,2), comm Number (7,2));

Creates a table T2 and specifies that the table space for this table is

Test1: CREATE TABLET2 (empno number (5) PRIMARY KEY, ename VARCHAR2 not NULL, Job VARCHAR2 (Ten), Mgr Number (5), HireDate DATE DEFAULT(sysdate), Sal number (7,2), comm Number (7,2) tablespace test1;

Insert record: INSERT INTO T1 values (MS, ' Wang ', ' it ', 25, ', 20,20);

Insert Date: INSERT INTO T1 values (102, ' Wang ', ' It ', 25,to_date (' 1980-12-17 ', ' yyyy-mm-dd '), 20,20

"Edit recommended" Oracle User name Rebuild index method to explain the Oracle Query user table space A brief analysis on the management method of Oracle database backup and recovery features five limitations of using Oracle external tables