The OS Database Administrators - Computer node creates an operating system-authenticated database administrator with SYSDBA privileges for every database instance on the computer. Several nodes for authenticating database administrators and operators appear. Specify the domain and computer name for the computer on which Oracle Database is installed.ĭouble-click Computers to display the computer you added.ĭouble-click the computer you added. To add a computer to the Microsoft Management Console tree:įrom the Start, select Programs, then select Oracle - HOME_NAME, then select Configuration and Migration Tools and then select Administration Assistant for Windows.ĭescription of the illustration addcomp.gif ![]() When you use Oracle Administration Assistant for Windows for the first time, it adds the local computer to its navigation tree. To assign a DNS name or change the primary DNS suffix, refer to your Microsoft documentation. Query Exception Class: class .OiilQueryException Query Exception: GetValueKeyNotFoundException SubKey = SYSTEM\CurrentControlSet\Services\Tcpip\Parameters If a computer is not identified with a Domain Name System (DNS) domain name, you will receive the following error message:Ĭalling query w32RegQueries1.7.0.17.0 RegGetValue HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_ HOME_NAME x or later databases remotely, you must set registry parameter OSAUTH_PREFIX_DOMAIN to true on the remote computer. Oracle Administration Assistant for Windows always creates users in Oracle Database with the domain name as the prefix. If you want to use Oracle Administration Assistant for Windows to manage a remote computer, you must have administrator privileges for the remote computer. Granting Operator Privileges for a Single Database ![]() Granting Administrator Privileges for a Single Database Viewing Database Authentication Parameter SettingsĬreating an External Operating System UserĬreating an External Operating System Role Granting Operator Privileges for All Databases on a Computer Granting Administrator Privileges for All Databases on a Computer This section describes how to perform the following tasks with Oracle Administration Assistant for Windows:Īdding a Computer and Saving Your Configuration SQL> CREATE USER username IDENTIFIED EXTERNALLY With Oracle Administration Assistant for Windows, none of the following need be done manually:Ĭreate local groups that match the database system identifier and roleĪssign domain users to these local groups In addition, Oracle Administration Assistant for Windows can create and grant local and external database roles to Windows domain users and global groups. Windows database operators (with the SYSOPER privilege) Windows database administrators (with the SYSDBA privilege) Regular Windows domain users and global groups as external users Oracle Administration Assistant for Windows runs from Microsoft Management Console and enables you to configure the following Oracle Database users and roles so that the Windows operating system can authenticate them, and they can access Oracle Database without a password: Oracle Administration Assistant for Windows
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |