Home » Server Options » RAC & Failsafe » Use of SYSDBA other than SYS Login (Oracle 12c, windows 2012)
Use of SYSDBA other than SYS Login [message #647863] Wed, 10 February 2016 05:49 Go to next message
muktha_22
Messages: 527
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
Re: Use of SYSDBA other than SYS Login [message #647868 is a reply to message #647863] Wed, 10 February 2016 07:11 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
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.

Re: Use of SYSDBA other than SYS Login [message #647893 is a reply to message #647868] Thu, 11 February 2016 02:14 Go to previous messageGo to next message
muktha_22
Messages: 527
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
Re: Use of SYSDBA other than SYS Login [message #647894 is a reply to message #647893] Thu, 11 February 2016 02:17 Go to previous message
Michel Cadot
Messages: 68625
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.

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


Current Time: Thu Mar 28 13:47:53 CDT 2024