OraFAQ Forum: Server Administration » insufficent privliges to other user(exclude sys)

Home » RDBMS Server » Server Administration » insufficent privliges to other user(exclude sys) (oracle10g window xp)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

insufficent privliges to other user(exclude sys) [message #508442]

Sat, 21 May 2011 04:06

manishseth
Messages: 1
Registered: May 2011
Location: udaipur(RAJASTHAN)

Junior Member

HI.......

WHEN I CONNECT TO SCOTT OR ANY KIND OF USER (EXCLUDE SYS)I CONNECT EASILY BUT PROBLUM WITH SCOTT OR OTHER THEY CANNOT BE
SHUTDOWN THE DATABASE AT THAT TIME THE ERROR ARISES ARE
ORA-01031: insufficient privileges SO OUR DATABASE CANT BE SHUT IT DOWN ........
IF ANY ONE HAS SOLUTION ABOUT THAT ERROR
SO SEND ME SOLUTION.......

THANKS

Report message to a moderator

Re: insufficent privliges to other user(exclude sys) [message #508444 is a reply to message #508442]

Sat, 21 May 2011 04:29

knight
Messages: 111
Registered: January 2009

Senior Member

database shutdown/startup should be done only by the privileged SYS user

Report message to a moderator

Re: insufficent privliges to other user(exclude sys) [message #508457 is a reply to message #508442]

Sat, 21 May 2011 09:01

aminelhamzaoui
Messages: 17
Registered: May 2011
Location: maroc

Junior Member

salam;
you should to give a privilége sysdba or sysoper to the simple users

i think like this

grant sysdba to scot;

Report message to a moderator

Re: insufficent privliges to other user(exclude sys) [message #508460 is a reply to message #508457]

Sat, 21 May 2011 09:14

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

you should to give a privilége sysdba or sysoper to the simple users

No, you should not, you should grant it ONLY to dba.

Regards
Michel

Report message to a moderator

Re: insufficent privliges to other user(exclude sys) [message #508462 is a reply to message #508460]

Sat, 21 May 2011 09:18

aminelhamzaoui
Messages: 17
Registered: May 2011
Location: maroc

Junior Member

sorry i mean a simple users "dba" of course

Report message to a moderator

Re: insufficent privliges to other user(exclude sys) [message #508530 is a reply to message #508462]

Mon, 23 May 2011 00:24

ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...

Senior Member

'SCOTT' is not a "DBA" User.Its sample schema thats it.

Sriram

Report message to a moderator

Previous Topic:	Control file corrupt
Next Topic:	how to recreate lobindex?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 23 16:07:06 CST 2025