regarding privileges [message #205864] |
Mon, 27 November 2006 23:32 |
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
|
|
|
|
|
Re: regarding privileges [message #206152 is a reply to message #206016] |
Tue, 28 November 2006 23:51 |
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?
|
|
|
|