Home IT Linux Windows Database Network Programming Server Mobile  
  Home \ Database \ Why did not Oracle privileges can also log in with sysdba     - MySQL innodb_table_stats table does not exist solution (Database)

- In the case of using cgroups Ubuntu 14.04 and Docker (Linux)

- Father of Python: Why Python zero-based index (Programming)

- CentOS 7 repair MBR and GRUB (Linux)

- PostgreSQL-XL installation and deployment (Database)

- Spring Data study notes -Helloworld (Programming)

- Linux smart small switch rfkill (Linux)

- Java Performance Tuning the proxy mode (Programming)

- Ubuntu how to install and use Objective-C (Linux)

- Linux foreground to background process switch (Linux)

- xCAT deployment (Linux)

- How do I delete a NEEDS RECOVERY rollback state of undo tablespace (Database)

- How to create a new file system / partitions under Linux terminal (Linux)

- How to Install Redis server on CentOS 7 (Server)

- Keepalived achieve high availability Nginx Reverse Proxy (Server)

- The basic principles for the protection of a good linux server security (Linux)

- Household use Linux Security (Linux)

- Oracle bdump file soaring (Database)

- Ubuntu 14.04 set auto sleep time (Linux)

- Python pickle module for simple use notes (Programming)

  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.
- Hadoop upload files error solved (Server)
- C # function (Programming)
- Linux centos rm directory does not prompt (Linux)
- Redis Design and Implementation study notes (Database)
- MySQL IO SSD attempt at optimization (Database)
- Volatile keyword in C language understanding (Programming)
- Solve ORA-01012: not logged on (Database)
- CentOS6 install Redis (Database)
- Unix / Linux commonly used to clean up disk space command (Linux)
- Linux Quick Install MongoDB (Database)
- Go build the locale under Windows (Linux)
- How to use the process on the desktop xkill end Linux (Linux)
- Visual Studio Code experience (Linux)
- What happens after the MySQL disk space is full (Database)
- Modify Linux SSH default port 22 in several ways (Linux)
- Linux system security norms (Linux)
- Installation and use of Linux Sniffer tool Tcpdump (Linux)
- C # / iOS / Android Universal Encryption and decryption (Programming)
- J2EE Example of Filter (Programming)
- How to install the latest version of the Eclipse in Ubuntu 14.04 (Linux)
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.