Stored Procedure check Permissions SQL Server 2000
Posted on 2004-03-31
I have a stored procedure that I pass a table name into as a parameter from vb.net. I could also pass in user name if I cannot get it from sql server.
Is it possible for me to see if a user executing the stored procedure has select rights on the table and exit if not?
My table permissions are set by roles (ie. I have three users in a role) I have granted permissions to the role and not each of the three users.