question

Leo avatar image
Leo asked

SQL 2008 Permissions Problem

I have set the permission for one of my Database called TestUser as SetupAdmin. There is 5 Tables in the Database. Assign SetupAdmin in ServerRole. Do I still need to go through individual Tables in UserMapping? Thanks.
sql-server-2008permissions
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Kev Riley avatar image
Kev Riley answered
SetupAdmin role is for managing linked servers - what exactly do you need the user TestUser to do?
5 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Leo avatar image Leo commented ·
Yes. Test User will manage the LinkServer and communicating data between Link Servers.
0 Likes 0 ·
Kev Riley avatar image Kev Riley ♦♦ commented ·
OK - so why do you think you need to go through tables? Do you have an issue?
0 Likes 0 ·
Leo avatar image Leo commented ·
Uh... Sorry Kev...I ment individual DATABASE in User Mapping? Thanks.
0 Likes 0 ·
Kev Riley avatar image Kev Riley ♦♦ commented ·
Ah ok - yes you will need to give the user access to each db that you want them to be able to get into.
0 Likes 0 ·
Leo avatar image Leo commented ·
Thanks Kev
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.