Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

quota question 1

Status
Not open for further replies.
kkudo

kkudo

MIS
Jan 10, 2001
4
US
All users have been set up with no quotas on any tablespace, but they are able to create records. Is this because the schema owner's profile is used or some other reason?
 
Sort by date Sort by votes
I think you have it exactly right. Individual users can insert rows because they have insert privileges on a table. If the inserts cause the table to add an extent, it's the table creator's quota that is checked when allocating the extra space.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Livia8
  • Locked
  • Question
Question re: SELECT DISTINCT 1
Replies
6
Views
785
SkipVought
S
Andrzejek
  • Locked
  • Question
Table design - virtual column question(?)
Replies
2
Views
144
ChrisHunt
ChrisHunt
torturedmind
  • Locked
  • Question
"SELECT" question
Replies
7
Views
169
torturedmind
torturedmind
dbrs4me
  • Locked
  • Question
SQL Left Outer Join question 1
Replies
1
Views
123
fredericofonseca
fredericofonseca
jamesflowers1974
  • Locked
  • Question
a question about creating a group in oracle SQL
Replies
1
Views
167
johnherman
johnherman

Part and Inventory Search

Sponsor

Back
Top