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 Chriss Miller 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
Joined
Jan 10, 2001
Messages
4
Location
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
Question re: SELECT DISTINCT
Replies
6
Views
1K
SkipVought
S
Andrzejek
  • Locked
  • Question Question
Table design - virtual column question(?)
Replies
2
Views
396
ChrisHunt
ChrisHunt
torturedmind
  • Locked
  • Question Question
"SELECT" question
Replies
7
Views
531
torturedmind
torturedmind
dbrs4me
  • Locked
  • Question Question
SQL Left Outer Join question
Replies
1
Views
328
fredericofonseca
fredericofonseca
jamesflowers1974
  • Locked
  • Question Question
a question about creating a group in oracle SQL
Replies
1
Views
382
johnherman
johnherman

Part and Inventory Search

Sponsor

Back
Top