Unlock a User in Oracle

Summary: in this tutorial, you will learn how to unlock a user in Oracle by using the ALTER USER ACCOUNT UNLOCK statement. To unlock a user in Oracle, you follow these steps: First, log in to the Oracle Database as a SYS user. Then, use ALTER USER statement to unlock the user as follows: Note that if you unlock an account … Read more Unlock a User in Oracle

Grant Object Privilege

Summary: in this tutorial, you will learn how to use the Oracle GRANT statement to grant SELECT object privilege on one or more tables to a user. Grant SELECT on a table to a user To grant the SELECT object privilege on a table to a user or role, you use the following statement: The following example illustrates how to grant the SELECT object privilege on a … Read more Grant Object Privilege

Privileges in Oracle

Summary: in this tutorial, you will learn how to use the Oracle GRANT ALL PRIVILEGES statement to grant all privileges to a user. Granting all privileges to a new user First, create a new user called super with a password by using the following CREATE USER statement: The super user created. Note that you should use a secure password instead of abcd124. Second, use the GRANT ALL … Read more Privileges in Oracle

Oracle ALTER USER

Summary: in this tutorial, you will learn how to use the Oracle ALTER USER statement to modify the authentication or database resource of a database user. The ALTER USER statement allows you to change the authentication or database resource characteristics of a database user. Generally speaking, to execute the ALTER USER statement, your account needs to have the ALTER USER system privilege. However,  … Read more Oracle ALTER USER

Oracle REVOKE Privileges

Summary: in this tutorial, you will learn how to use the Oracle REVOKE statement to revoke system and object privileges from a specific user. Introduction to Oracle REVOKE statement The Oracle REVOKE statement revokes system and object privileges from a user. Here is the basic syntax of the Oracle REVOKE statement: In this syntax: First, specify the system or object privileges that you … Read more Oracle REVOKE Privileges

Oracle GRANT Privileges

Summary: in this tutorial, you will learn how to use the Oracle GRANT statement to give privileges to a specific user. The overview of Oracle privileges After creating a user, you need to decide which actions the user can do in the Oracle database. In the CREATE USER tutorial, we used the GRANT statement to provide the user john the CREATE SESSION system privilege to enable … Read more Oracle GRANT Privileges