assigning DBA previleges to a user

[Former Member]

Hi to all DB experts..

Can any tell me how to assign DBA privileges to a user so that he can shutdown,

startup database..

he should have previleges as sysdba..

Thank you

kiran kumar

[Former Member]

we have to grant dba permission to the user.

and while we conn type the phrase as sysdba.

now the user will be able to shutdown/startup the database.

Thank you.

kiran kumar

[Former Member]

Hello Kiran,

What action did you perform to solve your problem?

Were the suggestions above not useful?

Regards,

Ammey Kesarkar

[Former Member]

your suggestion was useful ammey..

it is a good website.

however i have done is

i created a normal user say abc and granted him the dba rights...

while i am logging in as abc user i am just typing

conn abc as sysdba

now the user is able to shutdown the DB..

Note : i must tell when i am doing this..though i login as abc user , using the

pharse 'as sysdba' when i type show user it would show "sys" as current user..

that mean the user is redirected to 'sys'.

any suggestions from you.

thank you.

kiran kumar

[Former Member]

Hi,

When you connect "<u>AS SYSDBA</u>" you will <u>ALWAYS</u> connect as SYS.

No workaround, it is that way.

The identification is done at OS level, not at database level.

SYSDBA and SYSOPER are special administrative privileges that have nothing to do with having the role DBA. You are not connecting to the database as user "abc" as you saw.

Take a look here:

http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a96521/dba.htm#10431

[Former Member]

Hi,

If you only want the user to shutdown, do not give sysdba but sysoper.

[Former Member]

Kiran,

Sql>GRANT SYSDBA TO <user>;

SYSDBA is not an Oracle role or privilege SYSDBA is an operating system role that allows an O/S user to connect internal without a password.

When Oracle was installed it asked what O/S group would have SYSDBA and SYSOPER rights. In UNIX, the default group is dba.

change the REMOTE_LOGIN_PASSWORDFILE initialization parameter to EXCLUSIVE if not.

Regards

Vinod

[Former Member]

Hello Kiran,

Check the link below:

http://www.databasedesign-resource.com/users-in-oracle.html

Hope this would solve your query.

Regards,

Ammey Kesarkar

<i>'Award points for useful info'</i>