Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Why did not Oracle privileges can also log in with sysdba     - To install and deploy PHP environment under the CentOS (Server)

- Ubuntu file security removal tool (Linux)

- Security Configuration SQL Server 2000 database tutorial (Linux)

- C ++ based foundation: the difference between C and C ++ (Programming)

- Ubuntu will be written in a command file, executable file, source command (Linux)

- Linux Shell Understanding and Learning (Linux)

- learning Linux ls command examples (Linux)

- About phpwind 5.01-5.3 0day analysis of the article (Linux)

- Python pickle module for simple use notes (Programming)

- DVD production using CentOS installation source within the company Yum (Linux)

- Linux performance optimization tools perf top (Linux)

- Nine artifact control disk partition under Linux (Linux)

- Linux environment to configure Apache + Django + wsgi (Server)

- Alternative methods of intrusion bundled executable file new thinking (Linux)

- Git Rebase Tutorial: Using Git Rebase turn back the clock (Linux)

- Shell for loop (Programming)

- Linux Network Security: nmap port scanning software (Linux)

- Linux md5sum verify file integrity (Linux)

- Two strokes to improve development productivity Struts2 (Programming)

- OpenSUSE 13.1 OpenSUSE 12.3 and how to install Cinnamon 2.2 Desktop (Linux)

 
         
  Why did not Oracle privileges can also log in with sysdba
     
  Add Date : 2017-08-31      
         
       
         
  I just created a user, create user lisi identified by lisi; when I use sqlplus login:

cmd -> sqlplus lisi / lisi entrance -> lisi lisi as sysdba and then went in, so only the question.

Then I entered the administrator, the user will be deleted lisi

cmd -> sqlplus lisi / lisi entrance -> lisi lisi as sysdba and then went in, I doubt it deeper.

They were three answers:

Solution one:

For windows operating system, after Oracle database installation automatically installs a user group named ORA_DBA in the operating system, as long as the group of users that can

SYSDBA logged in a database and does not validate the SYS password. You can also create a user group named ORA_SID_DBA (SID for the instance name), the user belongs to the user group to be

Have more privileges. This is why you can show or when the system users,

Answer two:

Simply put, oracle sysdba to think you have the following three conditions

1. your oracle password file not been set up; (because oracle does not authenticate the user with sysdba default login)

2. Your identity is based on the operating system administrator login (regardless of who is logged on your computer, as long as the administrator is logged on, oracle recognize as sysdba, you can try to use the guest operating system login account, in that case, oracle you would not recognize as a DBA);

3. You are logged in as sysdba way (as long as you pick up as sysdba, no matter who is in front of you add a username and password, oracle think you are logged in as sysdba, user sys)

When the above three conditions are not met, the user is not logged on your sys, and if you log the user is not authorized to dba, then his authority can only be sure of the ordinary privileges.

Solution three:

It is possible, but then you add as sysdba landing is sysdba, and the user does not matter in front of you, if you create a new user user1, such as create user user1 identfied by 123, then grant him landing sys account the wording after permissions, you can directly conn user1 / 123, this connection is user1, if you conn user1 / 123 as sysdba, you connect or sysdba, and a little user1 relations front are gone.
     
         
       
         
  More:      
 
- Storm how to ensure that at least once semantics (Programming)
- CentOS modify yum update source (Linux)
- Android in the coordinate system and a method to obtain the coordinates (Programming)
- Linux system started to learn: Teaches you install Ubuntu 15.04 on VirtualBox (Linux)
- Use Visual Studio Code Development TypeScript (Linux)
- Oracle database file path changes (Database)
- Oracle database on the hit rate of query summary (Database)
- java.net.NoRouteToHostException of Hadoop problem: no route to host (Server)
- RHEL5.x RHEL6.x replace CentOS yum source (Linux)
- To use Android RecyclerView (Programming)
- Improve the Ubuntu SSH login authentication approach speed (Linux)
- How Oracle implements random reads from specific combinations (Database)
- redis configuration in detail (English) (Database)
- WinSCP to transfer text files will automatically convert the format (Linux)
- Getting Started with Linux system to learn: how to configure a static IP address for CentOS7 (Linux)
- 8 Docker knowledge you may not know (Server)
- Linux Getting Started tutorial: XWindow what (Linux)
- Single-node Hadoop installation notes distributed pseudo & (Server)
- Do not enter password login ssh (Server)
- Ubuntu Locale configuration problem solving Can not set LC_CTYPE (Linux)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.