How To Lock and Unlock a User Account

Q

How To Lock and Unlock a User Account? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges

✍: FYIcenter.com

A

If you want to lock a user account for a short period of time, and unlock it later, you can use the ALTER USER ... ACCOUNT command. The following sample script shows how to use this command:

>.\bin\sqlplus /nolog
SQL> connect SYSTEM/fyicenter

SQL> ALTER USER dev ACCOUNT LOCK;
User altered.

SQL> disconnect
SQL> CONNECT DEV/developer
ORA-28000: the account is locked

SQL> disconnect
SQL> connect SYSTEM/fyicenter

SQL> ALTER USER dev ACCOUNT UNLOCK;
User altered.

SQL> disconnect
SQL> CONNECT DEV/developer
Connected.

2007-05-01, 5585👍, 0💬

How To Lock and Unlock a User Account
How To Lock and Unlock a User Account? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges If you want to lock a user account for a short period of time, and unlock it later, you can use the ALTER USER ... ACCOUNT command. The following sample script shows how to use this command... 2007-05-01, 5586👍, 0💬

How To Revoke CREATE SESSION Privilege from a User
How To Revoke CREATE SESSION Privilege from a User? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges If you take away the CREATE SESSION privilege from a user, you can use the REVOKE command as shown in the following example script: >.\bin\sqlplus /nolog SQL> connect SYSTEM/fy... 2007-05-01, 5445👍, 0💬

How To Change User Password
How To Change User Password? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges If you want to change a user's password, you can log in as SYSTEM and use the ALTER USER command as shown in the following example: >.\bin\sqlplus /nolog SQL> connect SYSTEM/fyicenter Connected. SQL>... 2007-05-02, 5376👍, 0💬

What Privilege Is Needed for a User to Query Tables in Another Schema
What Privilege Is Needed for a User to Query Tables in Another Schema? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges For a user to run queries (SELECT statements) on tables of someone else's schema, he/she needs the SELECT ANY TABLE privilege. The following tutorial exercis... 2007-05-01, 5366👍, 0💬

How To Assign a Tablespace to a Users
How To Assign a Tablespace to a Users? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges When you create a new user, Oracle will assign the SYSTEM tablespace to the user by default. If you want to change this, you can assign a different table space to a user using the ALTER USE... 2007-05-01, 5314👍, 0💬

What Privilege Is Needed for a User to Connect to Oracle Server
What Privilege Is Needed for a User to Connect to Oracle Server? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges Oracle deny connection to users who has no CREATE SESSION privilege. Try the following tutorial exercise, you will find out how Oracle denies connection: >.\bin\sq... 2007-05-02, 5301👍, 0💬

How To Grant CREATE SESSION Privilege to a User
How To Grant CREATE SESSION Privilege to a User? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges If you want give a user the CREATE SESSION privilege, you can use the GRANT command. The following tutorial exercise shows you how to grant DEV the privilege to connect to the ser... 2007-05-02, 5163👍, 0💬

What Privilege Is Needed for a User to Create Tables
What Privilege Is Needed for a User to Create Tables? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges To be able to create tables in a user's own schema, the user needs to have the CREATE TABLE privilege, or the CREATE ANY TABLE privilege, which is more powerful, and allows t... 2007-05-01, 5076👍, 0💬

What Privilege Is Needed for a User to Create Indexes
What Privilege Is Needed for a User to Create Indexes? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges For a user to create indexes, he/she needs the same privilege as the creating tables. Just make sure he/she has the CREATE TABLE privilege. The following tutorial exercise g... 2007-05-01, 5068👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.