Q
Problem solve Get help with specific problems with your technologies, process and projects.

"Insufficient privileges" error

I tried to log on as SYSDBA and received "ORA-01031: insufficient privileges." I am using Oracle 8.0 on Windows NT. How I can resolve the above issue?

I did the following:
c:>sqlplus / nolog
SQL> connect / as sysdba
ORA-01031: insufficient privileges
I am using Oracle 8.0 on Windows NT. How I can resolve the above issue?
In order for you to connect to the data as "/ AS SYSDBA", you need to log on to the database server with an account that is a member of the OSDBA group. If you sign on to the database server as a user that is not part of this group, then you will need to provide a userid/password for a database user that has been granted the SYSDBA privilege. For instance, you will need to use something similar to:
connect sys/pswd as sysdba
This was last published in December 2005

Dig Deeper on Oracle database backup and recovery

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Join the conversation

1 comment

Send me notifications when other members comment.

Please create a username to comment.

How to export a single table in 10g under Solaris. Pl specify steps
Cancel

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close