Official Blogs Created By AMRESH KUMAR
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
Summary: in this tutorial, you will learn how to use the Oracle DROP USER to delete a user from the database. Introduction to Oracle DROP USER statement The DROP USER statement allows you to delete a user from the Oracle Database. If the user has schema objects, the DROP USER statement also can remove all the user’s schema objects along with the user. … Read more Oracle DROP 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
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
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
Summary: in this tutorial, you will learn how to use the Oracle CREATE USER statement to create a new user in the Oracle database. Introduction to Oracle CREATE USER statement The CREATE USER statement allows you to create a new database user which you can use to log in to the Oracle database. The basic syntax of the CREATE USER statement is as … Read more Oracle CREATE USER
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
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
Summary: in this tutorial, you will learn how to extend the size of a tablespace in the Oracle Database. When tablespaces of the database are full, you will not able to add or remove data on these tablespaces anymore. There are a few ways you can extend a tablespace. Extending a tablespace by adding a … Read more Oracle Extend 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