Problem connecting with sys schema in Report Builder 6i [message #432589] |
Wed, 25 November 2009 01:14 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
|
Hello All,
Am facing a problem with my report builder that i could not able to login .Am getting invalid username/password or login denied.
I have tried logging in toad by
Username sys
Password sys
connect as sysdba
its working fine there.
thanks in advance
Syed. .
|
|
|
|
|
|
|
|
Re: Problem connecting with sys schema in Report Builder 6i [message #432624 is a reply to message #432614] |
Wed, 25 November 2009 04:53 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
Just to re-enforce what Sriram said
Michel Cadot wrote
- Never ever use sys (or sysDBA) but for maintenance purpose (startup, shutdown, backup, recover)
- sys/sysDBA is special
- sys/sysDBA is Oracle proprietary (try to open a SR/TAR starting with "i did that with sys/sysDBA" and you'll see the immediate answer)
- sys/sysDBA does not act like any other user
- When you use sys/sysDBA Oracle deactivates some code path and activates others
- Whatever you do with sys/sysDBA will neither validate nor invalidate the same thing with any other user.
NEVER EVER use sys/sysDBA for anything that can be done by another user.
Use sys/sysDBA ONLY for something that can't be done by someone else.
|
|
|