How do I configure Password Manager to allow a login user other than sa? (NETIQKB36673)

  • 7736673
  • 02-Feb-2007
  • 17-Oct-2007

Resolution

goal
How do I configure Password Manager to allow a login user other than sa?

fact
VigilEnt Security Agent for Microsoft SQL Server 1.0x

fact
VigilEnt Password Manager for Sybase

fix

Here are the steps to change the login user for the Password Manager console.

  1. From the Password Manager console go to Admin tab and select whether you want the new administrator to administer users or templates.
  2. Select the privileges that you want that user to have.  Please keep in mind that some of these privileges will require various Sybase roles for example, change password requires sso role.  NOTE: You will get very clear error messages telling you what else is required.  
  3. Login to isle as sa and grant the following privileges to whoever you have selected as the admin:
  4. grant execute on sqlcqr_check_console_access to admin_name_here
    grant select on sqlcqr_alluserdata to admin_name_here


Additional Information

Formerly known as NETIQKB36673