MS SQL Server security - execute without select permission

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

execute without select permission

implacabile

2005-05-31, 11:23 am

hello all,
i'm using sql server 2005 beta 2.
i want to examine all select statements before executing them, so that i can
decide to execute the select or not.
I think creating a stored proc as single point of access for all select, and
revoking the select permission. this way the user cannot directly select
from
the table but can still execute the stored proc.
but if i want this "select stored proc" to be generic, it doesn't work:
if this sp contains an execute statement the users still need the select
permission
on the tables. is there some way to do it?
thanks.

Sponsored Links