Home » SQL & PL/SQL » SQL & PL/SQL » Re: Oracle 9i, SQLPLUSW Logon
Re: Oracle 9i, SQLPLUSW Logon [message #19682] Wed, 03 April 2002 10:12 Go to next message
Grant
Messages: 578
Registered: January 2002
Senior Member
Log in as sys. Once connected type:

connect sys/manager@tnsalias as sysdba

Report message to a moderator

Re: Oracle 9i, SQLPLUSW Logon [message #19685 is a reply to message #19682] Wed, 03 April 2002 14:46 Go to previous messageGo to next message
Murali
Messages: 54
Registered: December 1999
Member
I could do that.. but what i wanted is, when you user sqlplus of window version, i couldnt do that.. can you tell me how.

Report message to a moderator

Re: Oracle 9i, SQLPLUSW Logon [message #19702 is a reply to message #19685] Thu, 04 April 2002 05:40 Go to previous messageGo to next message
Grant
Messages: 578
Registered: January 2002
Senior Member
If you need read access to DBA views then grant SELECT_CATALOG_ROLE to the user. If the schema needs to do DBA stuff grant DBA to the schema.

Example:
SQL> grant SELECT_CATALOG_ROLE to scott;
SQL> grant DBA to scott;

Report message to a moderator

Re: Oracle 9i, SQLPLUSW Logon [message #19706 is a reply to message #19685] Thu, 04 April 2002 06:26 Go to previous message
Murali
Messages: 54
Registered: December 1999
Member
Well i got the login thing. Thanks for your response grant.

Report message to a moderator

Previous Topic: select statement inside cursor???
Next Topic: Sorting a PL/SQL table
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 23 02:43:07 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.