OraFAQ Forum: SQL & PL/SQL » Shutdown database

Home » SQL & PL/SQL » SQL & PL/SQL » Shutdown database

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

Shutdown database [message #8880]

Wed, 01 October 2003 08:00

Sudhakar
Messages: 34
Registered: May 2002

Member

I am practicing with Oracle 9i. I granted all the roles and privileges of SYS user to SCOTT user. When I issue the Shutdown command from SCOTT user, I get the message as 'insufficient privileges'. After this, I granted SYSDBA role to SCOTT. Even then I got the same message. Can SYS user alone shutdown the database? Is there any way, for other users to Shutdown the database?

Report message to a moderator

Re: Shutdown database [message #8881 is a reply to message #8880]

Wed, 01 October 2003 08:14

Thiru
Messages: 1089
Registered: May 2002

Senior Member

SQL> connect sys as sysdba
Enter password: *****
Connected.

SQL> create user test2 identified by test2;

User created.

SQL> grant connect,sysdba to test2;

Grant succeeded.

-- Now lets just connect as TEST2 user

SQL> connect test2/test2
Connected.
SQL> shutdown immediate;
ORA-01031: insufficient privileges

--Now lets connect TEST2 AS SYSDBA

SQL> connect test2/test2 as sysdba
Connected.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 131144544 bytes
Fixed Size 453472 bytes
Variable Size 88080384 bytes
Database Buffers 41943040 bytes
Redo Buffers 667648 bytes
Database mounted.
Database opened.
SQL> show user
USER is "SYS"

Hope this helps
Thiru

Report message to a moderator

Re: Shutdown database [message #8882 is a reply to message #8880]

Wed, 01 October 2003 08:15

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

did you create a passwordfile?
u granted sysdba to scott.
did u connect to datbase using scott as sysdba?
connect scott/tiger@dbname as sysdba

Report message to a moderator

Previous Topic:	Really very strange
Next Topic:	PARALLEL Hint

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 02:17:49 CDT 2024