Topic: Database Administration >> Normal users are able to login as sysdba
|
Disclaimer: The purpose of all dbapool forums including OCP and Other Oracle Certification forums is to help each other with specific issues but not to share dump and copyrighted exam content, materials or intellectual property.
You may review the entire Oracle Certification Program Candidate Agreement online Here.
|
|
|
|
| Title: Normal users are able to login as sysdba |
| Ashu |
Posted: Apr 29, 2007 08:22:17 AM |
Total Post: 13
Joined: Jan, 2007
|
Normal users like HR, SCOTT do not have access to data dictionary views
etc. However, then can login into the system as SYSDBA through the command -
connect hr/hr as sysdba;
connect scott/tiger as sysdba;
Also, when logging as SYSDBA, they can provide any password for connectivity i.e. the password is not checked.
By doing this, they can view the dictionary tables and perform other operations that are not enabled for them.
How, can we avoid them from logging as sysdba. |
|
|
 rsreddy28 |
| Posted: Apr 29, 2007 08:36:34 AM |  |
|
Total Post: 36
Joined: Mar, 2007
|
revoke all sysdba privileges that you have assigned to the users. and you should not face any more issues now.
lemme know if there are any probs.
bye,
raja
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
|
|
|
|
Forum Rules & Description
Who Can Read The Forum? Any registered user or guest
Who Can Post New Topics? Any registered user
Who Can Post Replies? Any registered user
|
| |
Get FREE Magazines
|
Top 10 Forum User
|
| Murtuja Khokhar | 857 |
| Mohammed Taj | 746 |
| positive fanatic | 483 |
| Jayanta Sur | 479 |
| Vigyan Kaushik | 386 |
| Gopu Gopi | 333 |
| Gitesh Trivedi | 322 |
| Vinoth Kumar | 264 |
| neeraj sharma | 258 |
| Ramesh Jois | 246 |
|
|
