Problem with table permissions

Angele

I have a setup of 28 users with Database Logins and different combinations of roles assigned to each one of them. The project went 'live' 3 months ago and we had no problems so far.

Lately we have problems related to table permissions for various routine operations. While performing standard tasks, the program asks for read permission to different tables. When comparing the permissions with old backups of the database and with those of Cronus, there are no apparent differences.

In one case, the program even asks for read permission to the Object table.

Any ideas? ](*,)

giulio.cipo

You could use the debugger to check with permission you need, sometimes there are special permission forn restrict table and you need to add this permission in the procedure and in some case there an error and who develop miss this permission.
Anyway best solution is check with debugger witch permission you need and check if is standard table.
giulio

Sbhat

For some table you have to give indirect permission which can be done using a developers license only. Have a developer go the concerned object and give indirect permission.

SB.