Oracle Database - Privileges

Card Puncher Data Processing

About

A user can connect with different levels of privileges:

Operating system accounts (user) must be members of the OSDBA or OSOPER groups to connect to the database with administrator privileges.

When you connect with a privilege issuing a 'CONNECT / AS SYSDBA' (OR SYSOPER), Oracle checks if your account is a member of the corresponding OS group (for Windows: 'ORA_sid_DBA' or 'ORA_DBA' group).





Discover More
Card Puncher Data Processing
Oracle Database - ORA-01720 - grant option does not exist for 'AnObject'

This error occurs when a user want to GRANT a privilege on an object where it is not the owner (directly or through a view). To be able to grant a privilege to a user on an object where you are not the...
Oracle Database 11gr2 Os Group
Oracle Database - Operating System Group

Operating System User and Group permit to allocate privileges. The documentation talks logical OS group (OSDBA, OSOPER, OSASM). Their implementation (their creation on the OS level) may be differ in...
Card Puncher Data Processing
Oracle Database - SYSASM privileges

SYSASM privileges for Automatic Storage Management files provide administrator privileges for storage file. In Oracle documentation, the operating system group whose members are granted SYSASM privileges...
Card Puncher Data Processing
Oracle Database - SYSDBA privilege

A user can connect with different levels of privileges, namely: SYSDBA (root or administrator) and SYSOPER. SYSOPER allows a user to perform basic operational tasks, but without the ability to look...
Card Puncher Data Processing
Oracle Database - SYSOPER privilege

A user can connect with different levels of privileges, namely: SYSDBA (the root of administrator of the database) and SYSOPER. SYSOPER allows a user to perform basic operational tasks, but without...
Card Puncher Data Processing
Oracle Database - User, Security

User User Description SYS The SYS user owns all base tables and user-accessable view of the data dictionary (Oracle configuration information). No Oracle user should ever alter (update, delete, or...
Card Puncher Data Processing
SQL Plus - Connect

CONNECT is a SQLPlus command that permits to make a connection as a user with a database (instance of). where: logon has the following syntax: username/password@connect_identifier proxy has the...



Share this page:
Follow us:
Task Runner