| ora-01031: insufficient privileges [message #69720] |
Mon, 25 February 2002 06:52  |
Tony
Messages: 190
Registered: June 2001
|
Senior Member |
|
|
|
just installed oracle server and am going through some excesises. Trying to log onto sqlplus with sysdba priviledges but get the error ora-01031: insufficient privileges. found some documentation that said I had to create an nt account with a user with sysdba privilidges. Created a sys, system accts both of which wont work. Any ideas-- I a new to this
|
|
|
|
| Re: ora-01031: insufficient privileges [message #69721 is a reply to message #69720] |
Mon, 25 February 2002 15:02  |
Nhu
Messages: 1
Registered: February 2002
|
Junior Member |
|
|
You need to grant some privileges such as:
- grant create user to tony (if you log in as tony)
and grant create grant any role to tony. Even though you are a user with sysdba, you still need these privileges granted directly to you. Check dba_sys_privs to see all the privileges you have. Hope this helps.
Nhu N.
|
|
|
|
|
|
|
|
| Re: ora-01031: insufficient privileges [message #72601 is a reply to message #69720] |
Tue, 29 July 2003 04:10 |
issa daas
Messages: 1
Registered: July 2003
|
Junior Member |
|
|
dear all
plz. i have a problem that i connect in devloper as system and i try to create table on sys and it give me this oracle error ora-01031: insufficient privileges
anyone can help me in this
best regards
issa
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
