Home » RDBMS Server » Server Administration » regarding privileges
regarding privileges [message #205864] Mon, 27 November 2006 23:32 Go to next message
frank.svs
Messages: 162
Registered: February 2006
Senior Member
Hi,

Can a normal user can perform database startup and shutdown?
How to do that.

Regards,
franky

Report message to a moderator

Re: regarding privileges [message #205868 is a reply to message #205864] Mon, 27 November 2006 23:46 Go to previous messageGo to next message
TanteKaethe
Messages: 4
Registered: November 2006
Junior Member
A user needs sysoper (less powerful than sysdba) or sysdba authorization. Then the user can execute commands like
startup open
shutdown normal

[Updated on: Mon, 27 November 2006 23:47]

Report message to a moderator

Re: regarding privileges [message #206016 is a reply to message #205864] Tue, 28 November 2006 06:16 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Only then, the user is no more 'normal'
Smile

Report message to a moderator

Re: regarding privileges [message #206152 is a reply to message #206016] Tue, 28 November 2006 23:51 Go to previous messageGo to next message
frank.svs
Messages: 162
Registered: February 2006
Senior Member
Hey thanks buddy,

But why the following

SYS> grant sysoper to scott;
c:\>sqlplus "scott/tiger@<service> as sysoper"
SQL>shutdown immediate
..
..
SQL> startup
..
..
But one thing i did'nt understand is that when i said
SQL>show user
User is "PUBLIC"

Again what is this. I expected "SCOTT"
Why?

Report message to a moderator

Re: regarding privileges [message #206242 is a reply to message #206152] Wed, 29 November 2006 04:51 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Expected behaviour
all in documentation.
http://www.lc.leidenuniv.nl/awcourse/oracle/server.920/a96521/dba.htm#10431
Quote:

When you connect with SYSDBA or SYSOPER privileges, you connect with a default schema, not with the schema that is generally associated with your username. For SYSDBA this schema is SYS; for SYSOPER the schema is PUBLIC.

Report message to a moderator

Previous Topic: Media recovery not enabled or manual archival only
Next Topic: Toad Error??
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 06:54:48 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.