Viewing 15 posts - 271 through 285 (of 6,105 total)
You're going around it the long way, at least from an overall security perspective.
Windows groups should be created for the explicit access to these confidential databases. If an existing group...
April 6, 2011 at 1:30 pm
There isn't a tool to do this. A query you could probably tie to Database Mail would be based on:
SELECT [name], LOGINPROPERTY([name], 'PasswordLastSetTime') AS 'Password_Date'
FROM sys.sql_logins
ORDER BY Password_Date ASC;
As to...
April 6, 2011 at 1:27 pm
Ludo Bernaerts (3/25/2011)
I configured a sql instance like mentioned in the article and see all connections coming in with Kerberos auth.
However the connections coming...
March 26, 2011 at 12:23 am
No. I would go into full-time vocational ministry working with children and youth. I love SQL Server and IT in general, but trying to find a balance between working IT...
March 22, 2011 at 6:29 pm
We are switching to using Windows authentication from an IIS server.
Do you mean you're switching to Windows Authentication from Anonymous Authentication with respect to the website/directory? If so, IUSR_* isn't...
February 20, 2011 at 1:46 am
Geoff A (1/24/2011)
is there a work around in SQL 2005, 2008, 2008 R2 that allows for ;
alter login [DomainGroupName] DISABLE;thanks
No, this behavior is by design. What you can do is:
DENY...
February 3, 2011 at 7:20 am
The public role is a role every user is a member of. It has permissions to hit some things, but no user defined objects (like created tables) by default. And...
January 14, 2011 at 11:19 am
You don't. SSMS connects in the context of the security account in which it was started. If you didn't use RunAs to start it under a different Windows account, that...
January 14, 2011 at 9:37 am
No. Having dbcreator only gives permissions to ALTER ANY DATABASE (meaning create/delete, too). This gives no permissions to create/alter SSIS packages stored in SQL Server or to schedule them for...
January 14, 2011 at 9:35 am
The major_id field varies depending on the securable being referenced. Probably the easiest way to handle this is to use the OBJECT_NAME() function like I did here:
January 13, 2011 at 6:44 am
Brandon Forest (11/17/2010)
When I started out in the IT field, DOS 2.11 was the dominant PC operating system. I learned to do everything in it, including tweaking...
November 17, 2010 at 12:41 pm
Steve Jones - SSC Editor (11/17/2010)
November 17, 2010 at 11:04 am
Lynn Pettis (11/17/2010)
Anyone who claims to be a 10, imho, is either a liar or too full of himself (or herself) as it is simple arrogance.
I think this...
November 17, 2010 at 11:02 am
Most folks I know who are checking membership in the Administrators group on a server do so using Computer Management (compmgmt.msc or Start >> Control Panel >> Administrative Tools >>...
November 5, 2010 at 2:23 am
Perry Whittle (11/4/2010)
K. Brian Kelley (11/4/2010)
November 4, 2010 at 2:37 pm
Viewing 15 posts - 271 through 285 (of 6,105 total)