| Bishal |
Posted: May 15, 2008 03:51:33 AM |
Total Post: 196
Joined: Apr, 2008
|
when i am trying to log as:
c:\>sqlplus
username:sys as sysdba
password:
I get following error
ora-01031: insufficient priviledges
but when i log on as:
c:\>sqlplus
username:system
password:
its logs me and i get
SQL>
What is the problem? how do i log on as SYS |
|
|
 Azaz |
| Posted: May 15, 2008 03:59:22 AM |  |
|
Total Post: 49
Joined: Mar, 2008
|
One need to mention "as sysdba" alongwith the password as a condition, while login with sys user in oracle.
|
|
|
|
|
| Bishal |
| Posted: May 15, 2008 04:04:45 AM | |
|
Total Post: 196
Joined: Apr, 2008
|
I KNOW THAT AZAZ... I AM SAYING I AM NOT ABLE TO LOG IN "SYS AS SYSDBA"
tHAT IS NOT A PROBLEM... WHILE WILL I GET INSUFFICIENT PRIVILEDGES ERROR...
|
|
|
|
|
| Azaz |
| Posted: May 15, 2008 04:13:17 AM | |
|
Total Post: 49
Joined: Mar, 2008
|
Ask the database administrator to perform the operation or re-grant the required privileges for sys user.
|
|
|
|
|
| Gitesh |
| Posted: May 15, 2008 05:10:35 AM | |
|
Total Post: 322
Joined: May, 2005
|
Privileges grant to sys user? !
|
|
|
|
|
| Murtuja |
| Posted: May 15, 2008 05:36:40 AM | |
|
Total Post: 816
Joined: Jan, 2006
|
Please check that user is in ORA_DBA group on your DB server.
steps
type compmgmt.msc in run
expand Local users and groups
and check user is in ORA_DBA group
|
|
|
|
|
| GOPU |
| Posted: May 15, 2008 05:52:33 AM | |
|
Total Post: 242
Joined: Apr, 2008
|
how to grant priviliges to sys user ???
|
|
|
|
|
| GOPU |
| Posted: May 15, 2008 06:08:38 AM | |
|
Total Post: 242
Joined: Apr, 2008
|
chech this metalink link
https://metalink.oracle.com/metalink/plsql/f?p=130:3:858875490435235276::::p3_database_id,p3_docid,p3_show_header,p3_show_help,p3_black_frame,p3_font:NOT,69642.1,1,1,1,helvetica
|
|
|
|
|
| Mohammed Taj |
| Posted: May 15, 2008 09:54:50 AM | |
|
Total Post: 704
Joined: Jul, 2007
|
http://dbataj.blogspot.com/2007/05/connection-problem-with-sys-user.html
|
|
|
|
|
| Murtuja |
| Posted: May 19, 2008 01:56:38 AM | |
|
Total Post: 816
Joined: Jan, 2006
|
Hi Bishal
Does any suggestion worked for you? Please post updates here.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
