granting [message #306479] |
Fri, 14 March 2008 08:22  |
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   |
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 #306505 is a reply to message #306479] |
Fri, 14 March 2008 09:05   |
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 #306646 is a reply to message #306630] |
Sat, 15 March 2008 07:06  |
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.
|
|
|