x

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.

more ▼

asked Oct 15, 2010 at 01:20 AM in Default

avatar image

Leo
1.6k 55 59 62

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

SetupAdmin role is for managing linked servers - what exactly do you need the user TestUser to do?

more ▼

answered Oct 15, 2010 at 01:34 AM

avatar image

Kev Riley ♦♦
65.8k 48 63 81

Yes. Test User will manage the LinkServer and communicating data between Link Servers.

Oct 15, 2010 at 01:56 AM Leo

OK - so why do you think you need to go through tables? Do you have an issue?

Oct 15, 2010 at 03:32 AM Kev Riley ♦♦

Uh... Sorry Kev...I ment individual DATABASE in User Mapping?

Thanks.

Oct 15, 2010 at 05:53 AM Leo

Ah ok - yes you will need to give the user access to each db that you want them to be able to get into.

Oct 15, 2010 at 07:24 AM Kev Riley ♦♦

Thanks Kev

Oct 15, 2010 at 08:17 AM Leo
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x2152
x119

asked: Oct 15, 2010 at 01:20 AM

Seen: 1298 times

Last Updated: Oct 15, 2010 at 01:36 AM

Copyright 2017 Redgate Software. Privacy Policy