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
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, July 19, 2016 1:50 AM
Points: 1,969, Visits: 3,153
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 @ 2:38 PM
Points: 44,919, Visits: 42,961
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
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, July 19, 2016 1:50 AM
Points: 1,969, Visits: 3,153
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 @ 2:38 PM
Points: 44,919, Visits: 42,961
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