How to Delete Pervasive Users without Administrator Rights

Added 08/15/05 - Article ID#: KB000188
 

Problem Overview

Night auditors may need to use the Pervasive Monitor to delete connections to the database that may be active in order to run RDP utilities and close the day.  RDP was requiring the night auditor to have Administrative rights, but this is no longer necessary. 

Tasks Requiring Pervasive Administrative Rights

The following section only applies to the server engine.  Pervasive.SQL2000i tasks that require administrative-level access at the operating system level and those that do not.  Administrative-level rights are required to:

• Create and configure named databases and tables
• Set engine configuration options
• View and set engine monitoring values
• View certain engine configuration settings

How Pervasive Administrative Rights are Granted

To have administrator-level access you must:

• Possess administrator-level rights on the computer itself, or
• Be a member of the operating system group Pervasive_Admin

The Pervasive_Admin option is offered so you can grant users administrative rights to the database engine without granting them administrative rights to the operating system where the database engine resides.

Grant User Database Administrator Rights on Windows 2000 Server

NOTE:  You must be logged onto the Windows server as a user with administrative rights.  Follow these steps to grant a user administrative-level access for each of the supported operating systems.

1. From the Start menu, select Settings | Control Panel | Users and Passwords
2. Select Advanced tab, then select Advanced User Management.
3. Select Groups folder.  From the menu, choose Action | New Group. 
4. Type in Pervasive_Admin as the group name.  Click on Add... to add users to this group.  When finished, click Create.
5. Add the new group to the appropriate user accounts