SQL Server 2008 Cannot find the object -
I have created several tables and stored procedures, an entry that is assigned to a role that is allowed to execute is. For 2 of the stored procedures, everything is working properly. But, for 2 of them, I get the following error:
Message 15151, Level 16, State 1, Process XX, Line 15
Object can not get 'XX' because it Is not in existence or you do not have permission.
I have checked that the process is present and permission for the role is executed on it. If I enter the database with login, then I can see the process and execute it, but I get the error above in the results tab in the results tab of the query window and in the message tab in the query window in the results window.
I'm looking for it for a few days and I can not find anywhere
Secondly, if your process uses a dynamic SQL, calling users have the right to those tables, not just for process
assume that your There is a process called passgate, which performs an execution that makes a selection. Your user will have the right to choose an account gate, along with the right to choose on the table (s) in the question.
This is for making a call for which a security reference is required. The current execution has been passed in the context of the user. If that user does not have the rights, you will get permission errors.
Comments
Post a Comment