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
Messages: 1
Registered: April 2014
Location: Bangalore
Junior Member

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.
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
Messages: 24269
Registered: January 2009
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.
Re: Query regarding 11g DBA [message #612363 is a reply to message #612360] Wed, 16 April 2014 10:01 Go to previous message
Messages: 520
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.

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

Current Time: Wed Nov 25 22:18:28 CST 2015

Total time taken to generate the page: 0.09645 seconds