About logins and roles

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Henry - 28 Aug 2007 01:24 GMT

Hi all expert,
I have create a logins called dbadmin
in what way can i restrict the logins to be able to access to a certain
database, or even certain tables inside database?
i have checked the security grid for accessing only certain database, such
as I checked the checkbox northwinds only, but finally i can gain access to
all db.

how to set exactly? please advise. and thanks in advance

Reply to this Message

Tom Moreau - 28 Aug 2007 03:09 GMT

Be sure that you did not add the login to any server-level groups. That may
be why you have permissions in all DBs.

Signature

Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau

Reply to this Message

Uri Dimant - 28 Aug 2007 06:29 GMT

Henry
In addition to Tom's reply , don't grant to the Login unwanted database
access. On the database level, deny select/insert/update/delete permissions
on the table for this user

> Hi all expert,
> I have create a logins called dbadmin
[quoted text clipped - 5 lines]
>
> how to set exactly? please advise. and thanks in advance

Reply to this Message