Ah - I understand. I thought you meant a sproc for each permission, not each action.
Quote:
|
Originally Posted by sqlguru
Can you give an example of this (or a link)?
|
The below essentially does this, just imagine it was a column in the Users table rather than a function
PERMISSIONS (Transact-SQL)
Where you stand on atomicity of column values may influence your thoughts on this.