Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Assign a Tablespace to a Users
How To Assign a Tablespace to a Users? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privileges
✍: 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.
2007-05-01, 4847👍, 0💬
Popular Posts:
How To Change System Global Area (SGA)? - Oracle DBA FAQ - Introduction to Oracle Database 10g Expre...
Can you explain in brief how can we implement threading ? Private Sub Form1_Load(ByVal sender As Sys...
How To Display a Past Time in Days, Hours and Minutes? - MySQL FAQs - Managing Tables and Running Qu...
Can we have shared events ? Yes, you can have shared event’s note only shared methods can raise shar...
What Are the Parameter Modes Supported by PL/SQL? - Oracle DBA FAQ - Creating Your Own PL/SQL Proced...