After installing the application I get the following error message:
Attachment 68389
From the way it reads I assume it is a matter of permissions set on the database for the user?
Printable View
After installing the application I get the following error message:
Attachment 68389
From the way it reads I assume it is a matter of permissions set on the database for the user?
Yes, that is what it looks like.
Yes, you can
GRANT EXECUTE ON tf_GetAllTicketNo TO username
(If you have a script for production), else do it via enterprise manager and set an object level permission.
So with the DBA's help, we can set the whole production group (data entry group) to access the DB to rum the application?
You're using Windows Authentication on your database? If yes, then you'll have to ask your DBAs to grant them permission, yes. They'll probably add those users to a database role and grant that role EXECUTE permissions on the SP.
Then we would have to give the same permissions for all the SPs that are in the App, or can the SPs be grouped somehow and permission given to the whaole group?
I don't think what you're asking exists - the permissions will need to be granted on an SP by SP basis. (Or the DBAs could make all of those users the DBOs, but that isn't going to happen :D )
Well we have a meeting scheduled to resolve this isssue tomorrow, I will pass on your suggestions.