OraFAQ Forum: Security » Insufficient privileges Problem

Home » RDBMS Server » Security » Insufficient privileges Problem

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Insufficient privileges Problem [message #285022]

Mon, 03 December 2007 02:29

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?

Report message to a moderator

Re: Insufficient privileges Problem [message #285025 is a reply to message #285022]

Mon, 03 December 2007 02:34

Michel Cadot
Messages: 54145
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Give quota on the tablespace to your user.
ALTER USER

Regards
Michel

Report message to a moderator

Re: Insufficient privileges Problem [message #285033 is a reply to message #285025]

Mon, 03 December 2007 02:50

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?

Report message to a moderator

Re: Insufficient privileges Problem [message #285035 is a reply to message #285022]

Mon, 03 December 2007 02:51

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

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...

Report message to a moderator

Re: Insufficient privileges Problem [message #285044 is a reply to message #285033]

Mon, 03 December 2007 03:18

Michel Cadot
Messages: 54145
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

Report message to a moderator

Re: Insufficient privileges Problem [message #285256 is a reply to message #285022]

Tue, 04 December 2007 02:20

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.

Report message to a moderator

Re: Insufficient privileges Problem [message #285257 is a reply to message #285022]

Tue, 04 December 2007 02:23

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Cut and paste of your error message here.

Report message to a moderator

Re: Insufficient privileges Problem [message #285267 is a reply to message #285256]

Tue, 04 December 2007 03:08

Michel Cadot
Messages: 54145
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

Report message to a moderator

Re: Insufficient privileges Problem [message #312319 is a reply to message #285025]

Tue, 08 April 2008 09:56

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

Report message to a moderator

Previous Topic:	Database security
Next Topic:	user expired

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 20 11:42:22 CDT 2013

Total time taken to generate the page: 0.17864 seconds