Why can my new user login as sysdba in oracle? Why can my new user login as sysdba in oracle? oracle oracle

Why can my new user login as sysdba in oracle?


Your windows user is part of the dba group (oradba). It uses Windows authentification to connect as sysdba. See this thread on AskTom:

"as sysdba" is extremely powerful, it uses OS AUTHENTICATION, it does not require database authentication (it is used to login before there is a "database" or even an "instance"!)

As a member of the dba group, you can login as sysdba with any database user. You can even login without a user: sqlplus / as sysdba.


This is how I would normally create a new user:

create user &1 identified by &2 default tablespace &3 temporary tablespace &4;

grant connect, resource to &1;grant alter session to &1;

** get the picture; also include other default privileges like "create ... " : sequence, synonym, table, view, database link select_catalog_role etc.