Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 545
  • Last Modified:

quota of tablespace

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
dbaseek
Asked:
dbaseek
  • 2
1 Solution
 
Shaju KumbalathCommented:
when u give resource role , user get  quata unlimited on tablespaces
0
 
Shaju KumbalathCommented:
so the table will be created successfully
0
 
hqassapCommented:
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now