Home » RDBMS Server » Server Administration » User like SYS
User like SYS [message #425206] Thu, 08 October 2009 01:04 Go to next message
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
Re: User like SYS [message #425208 is a reply to message #425206] Thu, 08 October 2009 01:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Only a SYSDBA or SYSOPER user can shutdown a database.

Regards
Michel
Re: User like SYS [message #427135 is a reply to message #425208] Wed, 21 October 2009 05:24 Go to previous message
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
Previous Topic: Objects displays incorrect date (merged 3)
Next Topic: NLS Settings DB level
Goto Forum:
  


Current Time: Sun Dec 11 02:17:49 CST 2016

Total time taken to generate the page: 0.07904 seconds