Solved

quota of tablespace

Posted on 2008-10-06
3
540 Views
Last Modified: 2013-12-18
Sir,
a user has "connect" and "resource" privileges by the DBA. The allocated quota on three tablespaces by the DBA
 Default Tablespace Quota 500 M
Tablespace first Quota 100 M
Tablespace second Quota 200 M
my   user trying to make a table which uses 300 M in tablespace second. Will he be successful?
0
Comment
Question by:dbaseek
  • 2
3 Comments
 
LVL 15

Accepted Solution

by:
Shaju Kumbalath earned 500 total points
ID: 22650090
when u give resource role , user get  quata unlimited on tablespaces
0
 
LVL 15

Expert Comment

by:Shaju Kumbalath
ID: 22650107
so the table will be created successfully
0
 
LVL 4

Expert Comment

by:hqassap
ID: 22657674
Since you grant the Resource Role to the user, he will get the Unlimited Tablespace privilege by default then the user will be able to create the 300 MB table on the 200 MB granted Tablespace.
To resolve this issue, you have to only revoke the unlimited Tablespace privilege and leave the other granted privileges and roles by executing the following command as DBA user:

SQLPLUS> revoke unlimited tablespace from <Username>;
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Create table from select - oracle 6 68
clob to char in oracle 3 94
Oracle DBLINKS From 11g to 8i 3 64
how to find out the count of records based on the subfolders paths 11 39
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video shows how to recover a database from a user managed backup

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question