| oracle sys authentication [message #348944] |
Thu, 18 September 2008 06:11  |
merhanatef
Messages: 28
Registered: September 2008
|
Junior Member |
|
|
hey guys ..
u know as a member in the os(windows xp) "ora_dba" group , i can log in to the database using th os authentication & not the password file..
it goes as follows :
----sql> / as sysdba
----SQL*Plus: Release 10.2.0.1.0 - Production on Thu Sep 18 ---------13:01:40 2008
----Copyright (c) 1982, 2005, Oracle. All rights reserved.
----Connected to:
----Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - -----Production
----With the Partitioning, OLAP and Data Mining options
now , i want the user to continue being a member in the ora_dba group , & @ the same time i dont want him to be able to log in using the "/ as sysdba " delimiter .. i want him to be obliged to use "sys/sys as sysdba", can i do that?
& also,is there a difference in the privileges a user gets when connected as sysdba while not being a member in the ora_dba group?
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
