Hello you all
I'm trying to change some subaccounts into a SL 2011 FP1, after I create the stored procedures and try to change just one subaccount I'm getting the error:
The SELECT permission was denied on the object "GLSetup",
any ideas on why is this happening and how to correct it?
*This post is locked for comments
Hello Erich
In this installation we are using SQL authentication.
Do you mean if I had done any queires on this database, yes I have done lots of selects and a few updates when a batch is out balance because of the multicurrency effect.
In the PSTL screen I did use the sa user to access the database and also tried the Master80 user with the same results.
Can you please give some more info on this?
Do you use SQL authentication or Windows integrated?
Have you executed direct SQL sentences on this database before?
As contradictory as it may seems, an active user inside SL DOES NOT have SELECT permission on the application tables. At least using Windows auth in SL 2011, a SQL feature called Application Role implements a lock on the regular database access.
At the login sequence, the SL client application issues the correct application role commands in order to get access. Any other SQL client that isn't invited doesn't get through. Only SL users with SYSADMIN enabled do have the access, or any other that was created as a bypass by the dba.
Share
Report
All responses (
Answers (
16
