Link to home
Create AccountLog in
Avatar of TempDBA
TempDBAFlag for India

asked on

Permission problem with reports

Hi,
   We have reports which are running fine at our place. When the same reports were tried by users from other location with other domain they are shown error. The error message is as:
"The permissions granted to user XYZ\UserName are insufficient for performing this operation".
The domainusergroup xyz is included in the security setting for the reports with the role provided as browser.
Can someone help with this.
ASKER CERTIFIED SOLUTION
Avatar of Fingo11
Fingo11

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of TempDBA

ASKER

@Fingo11: No there are no nesting levels. All the domains are the main domain and all the users within that domain can access. We don't have problem with two domains but other 3 domains are throwing the error.

@Emes: They have right as the request to the procecedures and sql text is being run by a dedicated sql server login.
can you log into sql server using that use and run the sql?

based on what you said yes. but lets test it. most of the time this error is a sql rights issue.

you may be calling a function or something in the code that you do not have rights to.

Avatar of TempDBA

ASKER

Got the problem solved. Though the user were added in the domain user, they were actually trying to connect through their local system which doesn't fall under the domain and that too without connecting through VPN. Silly mistake.