Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

sysadmin cannot alter login Expand / Collapse
Author
Message
Posted Monday, October 7, 2013 1:50 PM


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:17 AM
Points: 42,829, Visits: 35,962
Please note: 3 year old thread.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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 #1502346
Posted Monday, October 7, 2013 1:57 PM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 8:33 AM
Points: 153, Visits: 977
*lol*

...
(wasn't me... )


Andreas

---------------------------------------------------
MVP SQL Server
Microsoft Certified Master SQL Server 2008
Microsoft Certified Solutions Master Data Platform, SQL Server 2012
www.insidesql.org/blogs/andreaswolter
www.andreas-wolter.com
Post #1502350
Posted Thursday, October 10, 2013 12:34 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, July 30, 2014 6:57 AM
Points: 21, Visits: 306
FYI : If you use DENY then whoever are into that group lost SQL Server level access for that particular SQL Server even though they are in some other group which has DB reader etc.. permission on some database on same server . and You end up with error 18456....
Post #1503738
Posted Thursday, October 10, 2013 12:35 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, July 30, 2014 6:57 AM
Points: 21, Visits: 306
FYI : If you use DENY then whoever are into that group lost SQL Server level access for that particular SQL Server even though they are in some other group which has DB reader etc.. permission on some database on same server . and You end up with error 18456....
Post #1503739
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse