| ajay |
Posted: Mar 28, 2007 07:04:04 AM |
Total Post: 24
Joined: Mar, 2007
|
Hi DBA's
Here i am in problem....plz help me
if i give "/ as sysdba" i get connected to sys user..but i don't want any body to connect like this i want them to give proper username and password.
and if i give "scott/tiger as sysdba" again i can able to connect to sys user how to restrict this....plz help
thanks in advance |
|
|
 Jayanta |
| Posted: Mar 28, 2007 01:12:57 PM |  |
|
Total Post: 479
Joined: Feb, 2006
|
in windows there is a group called oradba gets created with oracle installation. any os user id member of oradba group can enjoy the privilege.
cheers!
|
|
|
|
|
| ajay |
| Posted: Mar 29, 2007 09:35:31 AM | |
|
Total Post: 24
Joined: Mar, 2007
|
thanks Jayanta....
i will try this today...and i will get back to u if any problem comes...
|
|
|
|
|
| ajay |
| Posted: Mar 29, 2007 09:40:37 AM | |
|
Total Post: 24
Joined: Mar, 2007
|
thanks Jayanta....once again
its working..
|
|
|
|
|
| Jayanta |
| Posted: Mar 29, 2007 12:39:55 PM | |
|
Total Post: 479
Joined: Feb, 2006
|
|
|
|
|
| Ashu |
| Posted: Apr 16, 2007 01:05:25 PM | |
|
Total Post: 13
Joined: Jan, 2007
|
Hi Jayanta,
I have recently completed my OCA.
I am unable to find the oradba group. The only file found is - oradba.exe
in ora90\database directory. The file is a coded one and cannot be properly viewed. Please suggest where and the way to find the oradba group and edit the same.
Thanks in advance
|
|
|
|
|
| Jayanta |
| Posted: Apr 18, 2007 01:33:41 PM | |
|
Total Post: 479
Joined: Feb, 2006
|
hello ashu,
in windows go to controlpanel then administrative tools then computer management then local users and groups.
cheers!
|
|
|
|
|
| Ashu |
| Posted: Apr 21, 2007 04:38:18 AM | |
|
Total Post: 13
Joined: Jan, 2007
|
|
|
|
|
| Jayanta |
| Posted: Apr 21, 2007 05:44:39 AM | |
|
Total Post: 479
Joined: Feb, 2006
|
|
|
|
|
| Mohammed Taj |
| Posted: Jul 30, 2007 12:56:39 AM | |
|
Total Post: 694
Joined: Jul, 2007
|
Hi,
If you set in (sqlnet.ora file) SQLNET.AUTHENITICATION_SERVICES=NONE then also no users connect to database without password.
Regards
Taj
http://dbataj.blogspot.com
|
|
|
|
|
| jogi |
| Posted: Aug 02, 2007 06:26:39 AM | |
|
Total Post: 21
Joined: Jul, 2007
|
"If you give sys as sysdba privilige then the user is sys and the privilige is sysdba"
"If you give scot/tiger as sysdba privilige then the user is sys".
"if you give scott tiger as sysoper privilige then the user is public"
in sysdba privilige you can have all the privilges, where as in sysoper only restricted privilges will be available
Thanks
prasad
|
|
|
|
|
| positive |
| Posted: Jun 29, 2008 03:57:50 PM | |
|
Total Post: 361
Joined: Jun, 2008
|
in unis dba,osdba are few groups used to restrict access.
http://neworacledba.blogspot.com/
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
