Skip to Content
User ManualDatabase Access ControlSetting Default Privilege

Setting Default Privilege

Overview

This is a feature to set the Default Privilege that connects by default when multiple Privilege permissions are granted to a single DB connection.

Setting Default Privilege

QueryPie Web > Database Access Control > Databases > Privileges

QueryPie Web > Database Access Control > Databases > Privileges

  1. When you have been granted 1 permission, all web, proxy, SQL Request, Export Request, and SQL Jobs connect with that permission without separate Default Privilege settings.
  2. When you have been granted 2 or more permissions, users must separately set Default Privilege.

QueryPie Web > Database Access Control > Databases > Privileges > Default Privilege Setting

QueryPie Web > Database Access Control > Databases > Privileges > Default Privilege Setting

  1. Click the Edit button or > Go to Settings link on the right of Privileges.
  2. In the Privilege section, select the Privilege to use as the default value among the granted permissions.
  3. Click the Save button to complete the Default Privilege setting.
  • When you have been granted 2 or more permissions but Default Privilege is not set, the first granted privilege becomes the default privilege. When connecting through agent proxy, SQL Request, Export Request, the DB is accessed with the permission selected as Default Privilege.
  • Default Privilege changes are provided in web and Multi-Agent. User Agent does not provide Default Privilege change functionality, and users must change it on the web page if they want to change the Privilege to connect to.
  • When Default Privilege is changed while already connected to a connection with Default Privilege, or when that permission is revoked, the existing session is disconnected and reconnected with the new Default permission.
  • When you have been granted 2 or more permissions and Default privilege is not set and becomes inactive due to exceeding the privilege deactivation period, you cannot connect through the agent. Even if Default privilege is set, you cannot connect if the status is inactive due to exceeding the privilege deactivation period.
Last updated on