If the user is a member of a Windows group with access, yes, that'd explain why they'd see the DBs when someone who isn't a member of the group wouldn't....

Jim's method is the only real way this works, unless they create a specific group on that domain with the users who need to be blocked. That way you're applying...

SA-1 (7/20/2010)

---

did you ever get this to work? I'm having similar problems, where some users aren't able to login to SQL Server while others part of the same group are...

are you running sp_setapprole in the same database where the app role was created? If you are, I'm not sure why you're getting that error. If there was a password...

Have you run a Profiler trace to ensure they're accessing the same object? Turned on the appropriate events to see exactly what error SQL Server is throwing (in case it's...

Here's an example how using a DDL trigger:

Granting limited permissions to create views in another schema in SQL Server - Part 2

No, there's not. You're best bet is to write a script that logs on to...

The sa account is...

RajaStyle123 (7/19/2010)

---

Is there a way to scan your network for sa passwords which are blank or default sa and / or XP_Cmdshell turned on ? I just want to...

You need to check all the group membership for that login. SQL Server will look at all Windows groups that have been given access and combine the permissions. So, for...

Use LOGINPROPERTY('LockoutTime') instead.

In the master database:

REVOKE EXECUTE ON sp_helptext FROM public;

This will drop the only permissions given to execute this stored procedure. That means only a member of the sysadmin fixed server...

A key is to break the ownership chain between the stored procedures and the table, but to keep it in place between the function and the table. You've got two...

I'm trying to understand what you've written as it looks like you've got the server name and the windows group mixed up.

If I have a server name of MyServer, then...

AKP (7/16/2010)

---

Thanks for your reply. But Here I want to know what are the security requirements for those abc/xyz domain user accounts if i want to run agent & Integration...