Alto Knowledge Base

« Double-click to Open File With .TIF Extension Causes Error | Main | The UltraDoc Add-in does not activate from Microsoft Outlook »

January 16, 2006

How to Replace Permissions on Existing Records for New User or Group Accounts

Summary

When a new user or group account is created, access permissions granted by setting accessible tables are not inherited by existing objects in those tables. There is currently no provision in either the UltraDoc or UltraDocWeb user interface for acomplishing this task. This article describes how to use a simple stored procedure to replace permissions on all child objects in a document, bundle, or collection table.

Requirements

• Access to the SQL Server hosting UltraDoc, and permission to run a stored procedure against the UltraDoc database.

Assigning Permissions to a Group Account

1. On the server that is running SQL Server, open SQL Server Query Analyzer, and type the following:

sp_udGrantGroupAccess <user name>, <table name>, <permission>

    <group name> = the Group_Name in the UD_Group table

    <table name> = the Table_Name in the Collections, Bundles,
        or Documents tables

    <permission> = can be "FULL", "WRITE", or "READ"

2. On the Query menu, click Execute (or press F5) to run the query.

Assigning Permissions to a User Account

1. On the server that is running SQL Server, open SQL Server Query Analyzer, and type the following:

sp_udGrantUserAccess <user name>, <table name>, <permission>

    <user name> = the User_Name in the UD_User table

    <table name> = the Table_Name in the Collections, Bundles,
        or Documents tables

    <permission> = can be "FULL", "WRITE", or "READ"

2. On the Query menu, click Execute (or press F5) to run the query.

More Information

For more information see the UltraDoc User Guide.

Posted by altotech at January 16, 2006 4:31 PM