Home » RDBMS Server » Security » Insufficient privileges Problem
Insufficient privileges Problem [message #285022] Mon, 03 December 2007 02:29 Go to next message
gaju_3112
Messages: 28
Registered: September 2007
Location: India
Junior Member

Whenever I try to create the table using sql *plus, I get following error message:-
Ora-01950: No privileges on table space 'Users'

What should I do? I think I have to use grant command, but how to use it I don't know. Can anybudy help me?
Re: Insufficient privileges Problem [message #285025 is a reply to message #285022] Mon, 03 December 2007 02:34 Go to previous messageGo to next message
Michel Cadot
Messages: 57642
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Give quota on the tablespace to your user.
ALTER USER

Regards
Michel
Re: Insufficient privileges Problem [message #285033 is a reply to message #285025] Mon, 03 December 2007 02:50 Go to previous messageGo to next message
gaju_3112
Messages: 28
Registered: September 2007
Location: India
Junior Member

I am new to the oracle. Can you please tell me what should I do exactly?
Re: Insufficient privileges Problem [message #285035 is a reply to message #285022] Mon, 03 December 2007 02:51 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

connect as dba users and invoke
alter user <your user name here> quota unlimited on users; 

[Updated on: Mon, 03 December 2007 02:53]

Report message to a moderator

Re: Insufficient privileges Problem [message #285037 is a reply to message #285033] Mon, 03 December 2007 02:53 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

As Micheal said,

Grant quota on tablespace to user and provide you exact sql syntax for this.
Did you try anything ???

alter user USERNAME quota xM/K on tablespacename;

May be it is work or may be not...again go through oracle documentation if above statement is not working...
Re: Insufficient privileges Problem [message #285044 is a reply to message #285033] Mon, 03 December 2007 03:18 Go to previous messageGo to next message
Michel Cadot
Messages: 57642
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Being new to Oracle is not an excuse to not click and read the link I posted on the documentation.

Regards
Michel
Re: Insufficient privileges Problem [message #285256 is a reply to message #285022] Tue, 04 December 2007 02:20 Go to previous messageGo to next message
gaju_3112
Messages: 28
Registered: September 2007
Location: India
Junior Member

How to connect as a dba users? Because using ALTER statement also, I am getting same error.
Re: Insufficient privileges Problem [message #285257 is a reply to message #285022] Tue, 04 December 2007 02:23 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Cut and paste of your error message here.
Re: Insufficient privileges Problem [message #285267 is a reply to message #285256] Tue, 04 December 2007 03:08 Go to previous messageGo to next message
Michel Cadot
Messages: 57642
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

How to connect as a dba users

The same way as with any other user but with an account that has DBA privileges.

Regards
Michel
Re: Insufficient privileges Problem [message #312319 is a reply to message #285025] Tue, 08 April 2008 09:56 Go to previous message
BPLManju
Messages: 1
Registered: April 2008
Junior Member
Hi all, sorry for the late joining and reply...

As couple of members said already..DBAs should always keep updating and reading the documentation.

Regards
Manju
Previous Topic: Database security
Next Topic: user expired
Goto Forum:
  


Current Time: Wed Apr 23 19:07:47 CDT 2014

Total time taken to generate the page: 0.08727 seconds