Oracle Administration Assistant for Windows NT 
   
 

Prev Next

Create and Manage Oracle Database Administrators, Operators, Users, and Roles with Windows NT

The following nodes that appear in the Microsoft Management Console enable you to create and manage Oracle database administrators, operators, users, and roles:
Node Name  This Node Lets You Create a...  How Do I Edit This Node? 

OS Database Administrators - Computer 

Windows NT user who can access all database instances on a single computer with SYSDBA privileges and without being prompted for a password. 

  1. Right click this node. 
  2. Choose Add/Remove. 
  3. Follow the on-screen instructions. 

OS Database Operators - Computer 

Windows NT user who can access all database instances on a single computer with SYSOPER privileges and without being prompted for a password. 

  1. Right click this node. 
  2. Choose Add/Remove. 
  3. Follow the on-screen instructions. 

External OS Users 

Windows NT user who can access the database without being prompted for a password. This user is similar to a regular database user to whom you assign standard database roles (CONNECT and RESOURCE), but do not want to assign SYSDBA and SYSOPER privileges. 
  1. Right click this node. 
  2. Choose Create. 
  3. Follow the on-screen instructions. 

Local Roles 

Database-managed role. Local roles can only be granted to an individual database user. You can create local roles with OS_ROLES set to TRUE in the INIT.ORA parameter file, but you cannot grant them to database users. To grant them, you must set OS_ROLES to FALSE. 
  1. Right click this node. 
  2. Choose Create. 
  3. Follow the on-screen instructions. 

External OS Roles 

Windows NT-managed role. This feature is available when OS_ROLES is set to TRUE in the INIT.ORA parameter file. External OS roles can be granted to both individual database users and NT global groups. 

  1. Right click this node. 
  2. Choose Create. 
  3. Follow the on-screen instructions. 

OS Database Administrators 

Windows NT user who can access a specific database instance on a single computer with SYSDBA privileges and without being prompted for a password. 

  1. Right click this node. 
  2. Choose Add/Remove. 
  3. Follow the on-screen instructions. 

OS Database Operators 

Windows NT user who can access a specific database instance on a single computer with SYSOPER privileges and without being prompted for a password.  
 

  1. Right click this node. 
  2. Choose Add/Remove. 
  3. Follow the on-screen instructions. 
 


Prev Next