Collections:
Assign a Tablespace to a User in Oracle
How To Assign a Tablespace to a Users in Oracle?
✍: FYIcenter.com
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 USER command. The following tutorial exercise changes user dev's default tablespace, and assigns 4MB of space to dev:
>.\bin\sqlplus /nolog SQL> CONNECT DEV/developer SQL> ALTER USER dev DEFAULT TABLESPACE USERS; User altered. SQL> ALTER USER dev QUOTA 4M ON USERS; User altered. SQL> disconnect SQL> CONNECT DEV/developer SQL> CREATE TABLE fyi (id NUMBER); Table created. SQL> DROP TABLE fyi; Table dropped. SQL> CREATE TABLE fyi (id NUMBER); Table created.
As you can see, "dev" can create and drop tables now. You can also let "dev" to create tables in any tablespace without any restriction by granting him the UNLIMITED TABLESPACE system privilege.
⇒ Privilege to Create Views in Oracle
⇐ Privilege to Create Tables in Oracle
2019-06-29, 2308🔥, 0💬
Popular Posts:
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and...
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...
Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard...
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...