- Oracle Database 12c Security Cookbook
- Zoran Pavlovi? Maja Veselica
- 380字
- 2021-07-02 16:43:14
The sysdg privilege – how, when, and why should you use it?
It is recommended that you use the sysdg administrative privilege instead of sysdba administrative privilege to perform operations related to data guard tasks.
Getting ready
For this recipe, you'll need:
- An existing database user (for example,
mike) and a password file in the 12c format if you want to complete it using a password-authenticated user - An existing OS user (for example,
kelly), who belongs to thedgdbaOS group in order to connect to the database using OS authentication
How to do it...
Instructions are split into sections for database authentication and OS authentication.
The instructions for database authentication are as follows:
- Connect to the database as
sysdba(or another user who can grant thesysdgprivilege):sqlplus / as sysdba - Grant
SYSDGprivilege to usermike:SQL> grant sysdg to mike; - Exit SQL*Plus, connect
mikeusing thedgmgrlcommand-line interface:SQL> exit $ dgmgrl DGMRRL> connect mike/test_1
How it works...
When you connect to the database as sysdg, you are connected as a predefined user, sysdg. Using the sysdg privilege, you can connect to the database even when it is not open.
After completing step 2 successfully in the Database authentication section, user mike, as expected, can grant/revoke sysdg privilege to/from another existing user. If you want to try it out, type the statements given here.
After you connect to the database using the sysdg administrative privilege, you can perform the following operations:
There's more...
You can't drop user sysdg. When you are connected to the database as sysdg, you are connected as sysdg user to the SYS schema:
SQL> connect / as sysdg Connected. SQL> show user USER is "SYSDG" SQL> select sys_context( 'userenv', 'current_schema' ) from dual; SYS_CONTEXT('USERENV','CURRENT_SCHEMA') ------------------------------------------------------------------ SYS
See also
- Creating password-authenticated users
- Creating and using OS-authenticated users
- Getting Started with Gulp（Second Edition）
- Expert C++
- Intel Galileo Essentials
- Mastering Objectoriented Python
- Rake Task Management Essentials
- Python Deep Learning
- 網頁設計與制作教程（HTML+CSS+JavaScript）（第2版）
- MySQL數據庫管理與開發（慕課版）
- 信息技術應用基礎
- 劍指MySQL：架構、調優與運維
- Couchbase Essentials
- SQL Server 入門很輕松（微課超值版）
- Mudbox 2013 Cookbook
- Node.js實戰：分布式系統中的后端服務開發
- Getting Started with the Lazarus IDE