Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Why did not Oracle privileges can also log in with sysdba     - Elasticsearch Kibana installation notes (Linux)

- Varnish achieve page jump (Server)

- Java framework for parallel study - ForkJoin (Programming)

- File encryption and decryption of Linux security mechanisms (Linux)

- Kali Linux 2.0 U disk installation errors Your installation cd-rom could not be mounted (Linux)

- Eclipse distributed management using GitHub project development (Linux)

- Camera-based face recognition OpenCV crawl and storage format (Python) (Linux)

- How to convert images, audio and video formats on Ubuntu (Linux)

- Java object serialization (Programming)

- OpenSIPS offline messaging feature set (Server)

- Configure the Linux kernel and use iptables to do port mapping (Linux)

- Linux System Getting Started Learning: the Linux Wireshark interface dead solve (Linux)

- Monitor log file (listener.log) (Database)

- apt-get and apt-cache show command examples (Linux)

- Linux iostat command example explanation (Linux)

- Nine tips to protect the security of Linux desktop (Linux)

- Hadoop 0.23 compile common errors (Server)

- Binary tree to the next node (Programming)

- JavaScript common array manipulation functions and usage (Programming)

- How do I delete a NEEDS RECOVERY rollback state of undo tablespace (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:      
 
- With screenfetch linux logo and basic hardware information display with cool Linux logo (Linux)
- Realization of Linux operating system illegal IP censorship (Linux)
- Redis performance test (Database)
- Python Django direct implementation of sql statement (Programming)
- Java Builder mode (Programming)
- These days have been tossing in the Linux under the ASP.NET 5, on the next in the other operating systems in the ASP.NET 5 or. NET applications, in order to complete the MS VM (CoreCLR) run is not far Reach, the effect of the application.

Cur
(Server)
- How to enhance the Nagios server security (Linux)
- Installation on the way to the root source Ubuntu Server 14.04 LTS version Odoo8.0 (Server)
- FileZilla 3.10.1.1 install on Ubuntu 14.10 (Linux)
- ActiveMQ-based shared file system HA solutions (Server)
- Oracle 10g, 11g database silent installation of small differences (Database)
- SELinux multi-level security (Linux)
- Spark parquet merge metadata problem (Server)
- Python object-oriented programming (Programming)
- Shell commonly commands (Linux)
- Mac Docker deploy development environment (Server)
- Use GNU / Linux broadcasting of television programs (Linux)
- Using monitoring tool dsniff (Linux)
- CentOS7 management of systemd (Linux)
- Linux server data backup (Server)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.