Home » SQL & PL/SQL » SQL & PL/SQL » granting (oracle 9i)
granting [message #306479] Fri, 14 March 2008 08:22 Go to next message
xost
Messages: 9
Registered: February 2008
Junior Member
Hi people
i have created a new user 'root' by sysdba ,
i have granted create session and table to the user 'root';

but when i login as root, and create a table , the table won't created , it shaw an error , there is a mistake in sentence no 1 ,

i'm sure i granted 'root' user to create a table, and i can't create a table , in the same time , i can create tables in Scott user ,

how to solve this problem , thanks anyway

[Updated on: Fri, 14 March 2008 08:24]

Report message to a moderator

Re: granting [message #306482 is a reply to message #306479] Fri, 14 March 2008 08:36 Go to previous messageGo to next message
flyboy
Messages: 1903
Registered: November 2006
Senior Member
Hi,
it would be good if you posted exactly what you did within error code and the full message. Thorough reading it could navigate you to the error reason. The piece you posted does not seem to be referring to the lack of privilege.
Re: granting [message #306485 is a reply to message #306479] Fri, 14 March 2008 08:39 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Give quota to your user.

Regards
Michel
Re: granting [message #306505 is a reply to message #306479] Fri, 14 March 2008 09:05 Go to previous messageGo to next message
xost
Messages: 9
Registered: February 2008
Junior Member
i'm sorry , the error is written in my language in which i don't know what would be exactly in english .
how can i change the language ?
Re: granting [message #306506 is a reply to message #306505] Fri, 14 March 2008 09:07 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator

Change your NLS_LANG but you can at least gives the error number, I think we will understand it.
But first try giving quota.

Regards
Michel
Re: granting [message #306630 is a reply to message #306479] Sat, 15 March 2008 04:10 Go to previous messageGo to next message
xost
Messages: 9
Registered: February 2008
Junior Member
http://up3.m5zn.com/uploads/7d667cf0e6.JPG
this is the picture of what the error say in my language ,
i'm working to change the language to english ,

thanks anyway for helping me
Re: granting [message #306646 is a reply to message #306630] Sat, 15 March 2008 07:06 Go to previous message
Frank
Messages: 7901
Registered: March 2000
Senior Member
The ORA-codes (in your case ORA-01950) are universal and independant of language settings.
You can use these codes as a search-term in Google, which will lead you to the solution within no time in over 90% of the cases.
Previous Topic: Dummy variable assignment not releasing pl/sql variable memory
Next Topic: Pull Data from Lotus Notes into Oracle server
Goto Forum:
  


Current Time: Sun Feb 16 00:34:45 CST 2025