RDBPROD: Privilege Errors When Accessing the SQLSRV_MANAGE Utility (Doc ID 72453.1)

Last updated on JUNE 07, 2017

Applies to:

Oracle SQL/Services for Rdb on OpenVMS - Version 7.1 and later
HP OpenVMS Alpha
HP OpenVMS Itanium
HP OpenVMS VAX

Symptoms

When you access the SQLSRV_MANAGE GUI utility, you receive the following error:

You want to create a separate SQL/Services service for each database user. Your users require the ability to stop and start their own service so that they can close the databases they connect to. The ability to stop and start a service requires access to the SQLSRV_MANAGE utility.

What privileges are required to run the SQLSRV_MANAGE utility? Can a non-privileged user stop and start his own service?  

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms