| grant unlimited tablespace [message #405012] |
Tue, 26 May 2009 01:20  |
vaibhavi
Messages: 21
Registered: April 2008
|
Junior Member |
|
|
Hello,
I am creating new user through stored procedure.
But when I give grants unlimited tablespace to new user I get error as follows :
create user test_usr13 identified by test_usr13 default tablespace users
grant unlimited tablespace to test_usr13
ERROR CODE : -1031
ERROR MSG : ORA-01031: insufficient privileges
Please suggest me on this .
Thanx.
[Updated on: Tue, 26 May 2009 01:24] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
| Re: grant unlimited tablespace [message #405040 is a reply to message #405014] |
Tue, 26 May 2009 03:05  |
Frank
Messages: 7901
Registered: March 2000
|
Senior Member |
|
|
| Michel Cadot wrote on Tue, 26 May 2009 08:25 | Anyway, you must NOT grant this privilege to any user.
|
If I have a database, dedicated to a single application, why would I not grant unlimited tablespace to the application-owner?
The thing is to shield this user, so others don't mess with it.
|
|
|
|
|
|
| Re: grant unlimited tablespace [message #405049 is a reply to message #405047] |
Tue, 26 May 2009 03:28 |
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
|
Filling the system tablespace is only an isue if your user somehow acquires the ability to create their own tables and write to them, or if you've screwed up and put the application tables into SYSTEM in the first place.
|
|
|
|
|
|
| Re: grant unlimited tablespace [message #405073 is a reply to message #405047] |
Tue, 26 May 2009 04:28 |
 |
Littlefoot
Messages: 21825
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
| Michel Cadot wrote on Tue, 26 May 2009 10:25 | @Littlefoot,
Why DBA exists?
|
Ummmmm ... to do database administration job? Are you saying that @vaibhavi is not a DBA? Well, I can't tell; all we know is that he is trying to create a new user through a stored procedure. He didn't do that as SYS or SYSTEM (good for him), so - maybe he uses another "DBA" user which, unfortunately, doesn't have all required privileges?
I'm sorry, but it appears that I don't understand the question.
My point was: if Oracle (as a corporation) thought that granting unlimited tablespace privilege was a bad idea, it would remove it from list of available privileges.
On the other hand, I guess that your statement was result of experience, documentation you've read, whatever ... therefore, I hoped that you'll explain why should that not be done. There are two options I can think of:- you've said that @vaibhavi should not do that (but only his DBA)
- you've said that granting this privilege should not be done, in any case
So which one is it (and, possibly, why)?
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
