1. how to revoke a sysdba or sysoper privilege given to a user?
2. how to restrict only a selected users for password authentication? when i tried this any user was able to login as
sysdba / sysoper eventhough i haven't granted them the required privileges?
Have you checked the view
V$PWFILE_USERS and compared the privileges to DBA_USERS to determine if everyone has SYSDBA and SYSOPER privileges?
Sometimes, there is an upper limit, set by the parameter ENTRIES.
OCP DBA 8i, 9i, 10g
U can query the v$pwfile_users view to find out the users who have got the sysdba and sysoper roles.
Login as sys or internal and revoke the sysdba and sysoper roles.
If u have given a user sysdba and sysoper roles he only can be able to login as sysdba and sysoper .Check the v$pwfile_users.
In case of any help please be free to ask me at email@example.com
Rohit Nirkhe,Oracle DBA,OCP 8i
Click Here to Expand Forum to Full Width