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.
For a description of the permissions granted to a Full Access user, see About User Permission Levels.
To set up a Full Access user:
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: