Right Problem

(0) Share

Report

Posted on by Wajahat Ali

1,500

i am using GP 8 with sql server 2000. Right now i have company database (CMPNY) and one other database (ABC). In ABC database another application insert its data and i pick this data and make an invoice in company database(CMPNY) from backend.

I have given undo functionality to all users to undo the created invoice from GP third party window. Poblem is that when i try to undo invoice it throw permission error. Because ABC database is not the part of DYNGRP.(my actual data reside in ABC database).

I have made DYNGRP role in ABC database and assign the right to the user manually ,it works fine. Now i have more than 400 users. So is there any other way to achieve this gole without mannualy assign rights to each user ?

Note : Because of performence issue and company policy i cannot create ABC database's table in company database (CMPNY).

Wajahat

*This post is locked for comments

All responses (1)

Answers (0)

Wajahat Ali 1,500 on at

Like (0)

Report

Re: Re: Right Problem

Hi Mariano

i have checked the script and found its working. One more thing i have to give SELECT Rights on two third party table to all user. Through this script i have added the users in ABC databse but they don't have any rights to get data.and i had to manually give the select right on two third aprty tables.

Thanks for your consideration to solve my problem.

Wajahat