OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » User like SYS

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

User like SYS [message #425206]

Thu, 08 October 2009 01:04

gir_sat
Messages: 64
Registered: October 2008
Location: Mumbai

Member

hi,

I have database on 9.2.0.8

I have created user as abc(like to create same user same as sys)
grant resouce, dba to abc.

conn abc/abc
connected
show user
"ABC"

archive log list;
insufficient privileges.

shutdown immeidate;
insufficient privileges.

Kindly let me know what others privileges i have to give to abc.

Thanks

Report message to a moderator

Re: User like SYS [message #425208 is a reply to message #425206]

Thu, 08 October 2009 01:13

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

Senior Member
Account Moderator

Only a SYSDBA or SYSOPER user can shutdown a database.

Regards
Michel

Report message to a moderator

Re: User like SYS [message #427135 is a reply to message #425208]

Wed, 21 October 2009 05:24

halim
Messages: 100
Registered: September 2008

Senior Member

SQL> conn / as sysdba
Connected.
SQL> create user sy identified by sy;

User created.

SQL> grant sysdba to sy;

Grant succeeded.

SQL> grant dba to sy;

Grant succeeded.

SQL> conn sy/sy

Connected.

SQL> shutdown immediate
ORA-01031: insufficient privileges
SQL>
SQL>
SQL> conn sy/sy as sysdba
Connected.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  612368384 bytes
Fixed Size                  1250428 bytes
Variable Size             192940932 bytes
Database Buffers          411041792 bytes
Redo Buffers                7135232 bytes
Database mounted.
Database opened.
SQL>

Regards
Halim

Report message to a moderator

Previous Topic:	Objects displays incorrect date (merged 3)
Next Topic:	NLS Settings DB level

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 16:30:08 CST 2024