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

Oracle Tablespace Group

Summary: in this tutorial, you will learn about Oracle temporary tablespace group and how to use the tablespace group effectively to optimize internal Oracle operations. Introduction to Oracle tablespace groups A tablespace group typically consists of multiple temporary tablespaces. A tablespace group allows a user to consume temporary space from multiple temporary tablespaces, instead of a single temporary … Read more Oracle Tablespace Group

Oracle Temporary Tablespace

Summary: in this tutorial, you will learn about the Oracle temporary tablespaces and how to manipulate the temporary tablespaces effectively. Introduction to Oracle temporary tablespaces A temporary tablespace, as its name implied, stores the temporary data that only exists during the database session. Oracle uses temporary tablespaces to improve the concurrency of multiple sort operations which do … Read more Oracle Temporary Tablespace

Oracle DROP TABLESPACE

Summary: in this tutorial, you will learn how to remove a tablespace from the database by using the Oracle DROP TABLESPACE statement. Introduction to Oracle DROP TABLESPACE statement The DROP TABLESPACE allows you to remove a tablespace from the database. Here is the basic syntax of the DROP TABLESPACE statement: In this syntax: First, specify the name of the tablespace that you want to drop … Read more Oracle DROP TABLESPACE