Lock and Unlock a User Account in Oracle

Q

How To Lock and Unlock a User Account in Oracle?

✍: 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.

⇒ Privilege to Create Tables in Oracle

⇐ Revoke CREATE SESSION Privilege in Oracle

⇑ Managing Oracle User Accounts, Schema and Privileges

⇑⇑ Oracle Database Tutorials

2019-06-29, 1568🔥, 0💬

Privilege to Create Tables in Oracle
What Privilege Is Needed for a User to Create Tables in Oracle? 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 the user to create tables in other user's schema. The following... 2019-06-29, 1824🔥, 0💬

Change User Password in Oracle
How To Change User Password in Oracle? 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> ALTER USER DEV IDENTIFIED BY beginner; U... 2019-07-09, 1708🔥, 0💬

Privilege to Create Views in Oracle
What Privilege Is Needed for a User to Create Views in Oracle? To be able to create views in a user's own schema, the user needs to have the CREATE VIEW privilege, or the CREATE ANY VIEW privilege, which is more powerful, and allows the user to create views in other user's schema. The following tuto... 2019-06-29, 1689🔥, 0💬

Revoke CREATE SESSION Privilege in Oracle
How To Revoke CREATE SESSION Privilege from a User in Oracle? 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/fyicenter SQL> REVOKE CREATE SESSION FROM d... 2019-07-09, 1654🔥, 0💬

Privilege Needed to Connect to Oracle Server in Oracle
What Privilege Is Needed for a User to Connect to Oracle Server in Oracle? 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\sqlplus /nolog SQL> connect SYSTEM/fyicenter SQL&a... 2019-07-09, 1630🔥, 0💬

Privilege to Query Tables in Another Schema in Oracle
What Privilege Is Needed for a User to Query Tables in Another Schema in Oracle? 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 exercise gives you a good example of granting "dev" to query tables i... 2019-06-11, 1628🔥, 0💬

Grant CREATE SESSION Privilege in Oracle
How To Grant CREATE SESSION Privilege to a User in Oracle? 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 server: >.\bin\sqlplus /nolog SQL> connect SYSTEM/f... 2019-07-09, 1618🔥, 0💬

Delete a User Account in Oracle
How To Delete a User Account in Oracle? If you want to delete a user account and its associated schema, you can log in as SYSTEM and use the DROP USER command as shown in the following example: >.\bin\sqlplus /nolog SQL> connect SYSTEM/fyicenter Connected. SQL> DROP USER DEV CAS... 2019-07-09, 1593🔥, 0💬

Privilege to Create Indexes in Oracle
What Privilege Is Needed for a User to Create Indexes in Oracle? 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 gives you a good example on creating view privilege: >.\... 2019-06-29, 1585🔥, 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.