Granting Full Application Access and DBO Security Permissions

Vista enables certain users to have full access to the Vista application and/or database. This topic discusses setting up Full Access users and granting users DBO permissions.

There are several levels of security administrator permissions. For more information on what permissions each level has, see About User Permission Levels.

Granting Full Access to the Application

Granting full access is typically done only when you want to give total access to your system to a particular user, such as the vcssupport account or system administrators. If the user has already had specific security settings set up, then granting full access will add security only for items not previously set up.

Important: Report security will be applied for SSRS reports only if the Sync Security check box is selected in RP RS Server.

For a description of the permissions granted to a Full Access user, see About User Permission Levels.

To set up a Full Access user:

  1. Set up the user as a Vista user. See Setting Up Users.
  2. On the Grant tab of VA User Profile, click the Grant Full Access button.
  3. Make any additional needed changes in the form, and save the form.

Granting DBO Privileges

Granting database ownership privileges is typically done only when you want to provide total access to your Viewpoint database to particular users, such as the vcssupport account or system administrators.

You can grant these privileges using VA User Profile only if you have SQL permissions to grant database owner privileges.

Following the steps below grants the selected user SQL database owner (DBO) privileges. Some of these privileges include:

  • granting and revoking access
  • creating tables
  • creating stored procedures and views
  • running backups
  • scheduling jobs
  • dropping the database

To grant DBO privileges:

  1. Set up the user as a Vista user. See Setting Up Users.
  2. On the Grant tab of VA User Profile, click the Grant DBO button.
  3. Make any additional needed changes in the form, and save the form.

    To remove DBO privileges, you must use Microsoft SQL Management Studio (or some other 3rd party management tool) to remove the privileges.