September 6, 2008 at 9:54 am
Hi,
is it possible to restrict a user to access specific tables in the database (no reading, no writting).
Thanks.
September 6, 2008 at 11:31 am
you could deny a user access to a table using:
DENY { ALL [ PRIVILEGES ] }
| permission [ ( column [ ,...n ] ) ] [ ,...n ]
[ ON [ class :: ] securable ] TO principal [ ,...n ]
[ CASCADE] [ AS principal ]
Check "deny " in Books Online.
I haven't tested this for a user being member of sysadmin. :unsure:
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
September 6, 2008 at 8:13 pm
Users have no rights to tables unless they are granted. If they are granted as part of a role or rights, then you can use DENY as listed above.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply