OraFAQ Forum: RAC & Failsafe » Use of SYSDBA other than SYS Login

Home » Server Options » RAC & Failsafe » Use of SYSDBA other than SYS Login (Oracle 12c, windows 2012)

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

Use of SYSDBA other than SYS Login [message #647863]

Wed, 10 February 2016 05:49

muktha_22
Messages: 526
Registered: December 2009

Senior Member

Hello All,

I have some doubt, kindly clarify.

1) user AA exist in DB.
2) Also part of the ORA_DBA group.
3) With sys login, GRANT SYSDBA TO AA;
4) Connecting AA as sysdba
5) SHOW USER shows SYS as the logged in user.

Ultimately, the connection made through SYS login.

In which scenario this will work out.

Regards
Muktha

Report message to a moderator

Re: Use of SYSDBA other than SYS Login [message #647868 is a reply to message #647863]

Wed, 10 February 2016 07:11

Michel Cadot
Messages: 66849
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

This works as expected.
Maybe you should think to start to read the documentation.
And this has not a RAC question, maybe you should think to start to read the purpose of each forum.
Maybe you should start to think about learning to read.

Report message to a moderator

Re: Use of SYSDBA other than SYS Login [message #647893 is a reply to message #647868]

Thu, 11 February 2016 02:14

muktha_22
Messages: 526
Registered: December 2009

Senior Member

Hi Michel,

Yes I am reading, but when I am lost in google, just need a hint from you all.

Sorry for the post made in the RAC forum.

Regards
Muktha

Report message to a moderator

Re: Use of SYSDBA other than SYS Login [message #647894 is a reply to message #647893]

Thu, 11 February 2016 02:17

Michel Cadot
Messages: 66849
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

So you abuse of us to read the documentation for you and waste our time which can be spent to help someone with a REAL problem.
Nice guy.

Report message to a moderator

Previous Topic:	Making Standby DB from RAC
Next Topic:	addnode.sh script hang

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 18 15:39:49 CST 2020