Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Why did not Oracle privileges can also log in with sysdba     - DataGuard the MRP can not start to analyze and solve problems (Database)

- Java reflection technology explain (Programming)

- Linux, MySQL / MariaDB Galera Cluster Setup Process (Database)

- Linux file and directory permissions settings (Linux)

- Linux support exFAT and NTFS (Linux)

- The Sublime Text 3 configuration file (Linux)

- How to install and use the Snort in Ubuntu 15.04 (Linux)

- DELL D630 Wireless LAN Driver Installation CentOS6 (Linux)

- Basic Tutorial: Linux novice should know 26 commands (Linux)

- Gitolite how to import other Git repositories (Server)

- RHEL7 Apache MPM configuration (Server)

- Rails project prepared some tips small experience (Linux)

- Management Linux Container with Docker in Ubuntu (Linux)

- Linux hard drive failure Case Studies (Linux)

- Linux file time Comments ctime mtime atime (Linux)

- Ease of use "Explain Shell" script to understand Shell command (Linux)

- Cobbler batch install Ubuntu / CentOS system (Linux)

- GRUB and Linux system repair (Linux)

- RHEL 6.6 install GNOME desktop environment (Linux)

- Zabbix monitoring Oracle Database use Orabbix plug (Enhanced Edition) (Database)

 
         
  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:      
 
- How to make Linux a non-root user uses less than 1024 ports (Linux)
- How do you turn on and off IPv6 address on Fedora (Linux)
- Linux ps command (Linux)
- Linux how to prohibit the use of Ping command (Linux)
- [Errno 4] IOError: [Errno ftp error] with yum appears as a workaround (Linux)
- Bash How to read a file line by line (Programming)
- Use regular expressions to check whether the input box to enter a URL (Programming)
- MySQL in order by inaccurate results in problems and solutions (Database)
- Use cmake to compile and install MySQL 5.5 (Database)
- Linux user directory (Linux)
- Linux, modify / etc / profile file (Linux)
- Linux Nginx installation and configuration instructions (Server)
- Close and limit unused ports computer server security protection (Linux)
- DataGuard the MRP can not start to analyze and solve problems (Database)
- To install HDRMerge 0.4.3 under ubuntu (Linux)
- Zombie process under Linux (Linux)
- Use OpenSSL to generate a certificate (Linux)
- Several Methods of SSH Auto - login (Linux)
- OpenNMS separate database (Server)
- C ++ based socket communication TCP and UDP (Programming)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.