Configuring Adaptive Server to use granular permissions

To configure Adaptive Server to use granular permissions:

  1. Enable the security and directory services license, ASE_SECDIRS. See the Sybase Software Asset Management Users Guide.

  2. Enable the enable granular permissions configuration parameter, which requires the sso_role, and checks out the ASE_SECDIRS license. Disabling enable granular permissions requires the granular system privilege, manage security configuration and checks the license back in.

To turn on enable granular permissions, Adaptive Server verifies that at least one unlocked account has the manage server permissions privilege, and at least one unlocked account has the manage security permissions privilege. When disabling enable granular permissions, Adaptive Server verifies the server has at least one unlocked account with the sso_role, and that at least one unlocked account has the sa_role.