Awesomo
SSC Veteran
Points: 265
More actions
May 4, 2011 at 7:08 am
#235644
Hi
Using SQL Server 2008 R2.
I want to check the permission on a table.
If I select Permissions, there are no entries in the Users or Roles area. Does that mean that no one has permissions for that table?
Thanks
Johan Bijnens
SSC Guru
Points: 135615
May 4, 2011 at 8:00 am
#1319782
no !
e.g. db_datareader database group is allowed to read all data of all tables and views
do you have the needed authority to view that info ?
JohanLearn 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 and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply