Home » RDBMS Server » Server Administration » Query regarding 11g DBA (Oracle 11g release 11.2.0, Windows 7)
Query regarding 11g DBA [message #612360] Wed, 16 April 2014 09:43 Go to next message
manojswarnakar@gmail.com
Messages: 1
Registered: April 2014
Location: Bangalore
Junior Member
Hi,

I created a user 'scott' and assigned 'sysdba' persmission. When i try to logon with user 'scott' as 'sysdba' and try to access V$ and dba_ views, i am unable to do so. Please suggest.

Report message to a moderator

Re: Query regarding 11g DBA [message #612362 is a reply to message #612360] Wed, 16 April 2014 09:54 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Welcome to this forum.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and please read http://www.orafaq.com/forum/t/174502/102589/

>I created a user 'scott' and assigned 'sysdba' persmission.
do NOT tell us what you did.
SHOW us using COPY & PASTE what you did & how Oracle responded.

Report message to a moderator

Re: Query regarding 11g DBA [message #612363 is a reply to message #612360] Wed, 16 April 2014 10:01 Go to previous message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
"unable to do so" is not an actionable error message.

If you are "unable" to do something, your attempt should have resulted in an error code and message text. Knowing that error code AND message text is key to unraveling your mystery. Equally important is knowing the exact statement that produced the error.


Unfortunately, you chose not to share that information.

Report message to a moderator

Previous Topic: Oracle 11 install using response file
Next Topic: ORACLE_HOME
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Oct 01 01:32:42 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.