Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Can we restrict windows authentication login to only selected databases..? Expand / Collapse
Author
Message
Posted Tuesday, March 10, 2009 8:50 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 1:19 AM
Points: 2,004, Visits: 3,187
Hi All,
Can we restrict windows authentication login to only selected databases..? Is it possible..?


Thanks.
Post #672503
Posted Tuesday, March 10, 2009 9:03 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 12:12 AM
Points: 45,618, Visits: 44,146
Sure. Any login, windows or SQL will only have access to the databases it's granted access to. If you don't grant access to a database the person using the login won't be able to access it.


Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #672520
Posted Tuesday, March 10, 2009 9:11 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 1:19 AM
Points: 2,004, Visits: 3,187
Can you pls explain it in details...
I usualy assign database rights to SQL login...
How can I do the same with windows..?
Post #672531
Posted Tuesday, March 10, 2009 9:19 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 12:12 AM
Points: 45,618, Visits: 44,146
swmsan (3/10/2009)
How can I do the same with windows..?


Exactly the same way you do with a SQL login.



Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #672539
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse