I'm currently using RHEL 5 and Oracle 11g.
I use DBCA to create Oracle database with all default options available. The problem is that when I create a new user on that database, this user can connect to the database with sysdba privilege although it is not granted any privileges.
create user backup_admin identified by password default tablespace users;
sqlplus backup_admin as sysdba
What to do to restrict the user from connecting as sysdba?