I have a snag -

I have one stored procedure that is meant to return to the database admins a list of logins and whether they're active or not. That...

IINM, given that the privilege to run a job is a server-level permission, you may want something similar to what I decided to do for handling self-service logins. See this...

Evil Kraig F (10/31/2011)

---

Yeah, it's one ROYAL PITA. You're not just on the hook at...

I wonder if I'm missing something when people say they don't like having 1000 logins.

While opc.three made good point about concurrent users (thanks!), I'm thinking it's not that big deal...

Thanks for some pointers.

The current project I'm working on, it seemed that the application managing its own logins/users was the lesser of two evils, since there's several other routines that...

After running into permission errors again, I've edited my previous post - I actually had made an incorrect assumption about the db_securityadmin. I thought it had the ALTER ANY USER...

Jeff, I'm so glad you mentioned certificates. Apparently I didn't read too carefully or understood Erland's section and got fixated on TRUSTWORTHY which I still think is wrong solution. But...

So far, I've not gotten any suggestions where I may have done it wrong and thus avoid the need to grant IMPERSONATE and manage this within a stored procedure, I'm...

Jeff, that would not be the first time I've overcomplicated my life.

Just to put aside all the mental junk, I decided to do this all from scratch. Here's the...

Thanks, Jeff.

The database was originally owned by my Windows login which is a member of sysadmin. However, I went and changed the owner to sa. I then altered my sproc...

Hopefully not too soon to bump the thread and see if anyone has any suggestions or maybe a better approach to achieve the goal of enabling a database user to...

In this case, ability to create new logins -- using SQL Server auth ( 🙁 ), and we wanted to have a way to allow "admins" of the database to...

Lynn Pettis (10/26/2011)

---

I'll have to play with this at home. I know where I am working now, they have a procedure dbo.TruncateTable used to truncate a table without giving...

Just a quick addendum to hopefully demonstrate the crux of problem.

This will fail in an error:

EXECUTE AS USER = 'dbo';

EXECUTE AS LOGIN = 'proxylogin';

REVERT;

REVERT;

Even though the user 'dbo' is actually...

I really hope I'm wrong but this article seems to suggest that this does not work this way when we're talking about impersonating a server principal.

Article

In this, it says you...