How do you grant a database (not NT) user 'sa' privileges?
You need to rephrase your question. Make a clear distinction between logins,
database users, and also which release of SQL Server you're on.
Database users only have permissions to objects in the database. Even sa
gets its privileges in a database by mapping to the dbo user in each
This should be a simple task. I have not located the system table or
combination of tables that I can select from or join to determine all users
with sa privilege.
I am seeking a Transact-SQL query to list all users with sa privilege or sa
equivalence. Certainly this should be simple and it must be possible.
This particular business situation is against a 6.5 instance.
BTW, I've seen the SQL Security Manager GUI interface. This GUI tool lets
you expand a listing of sa accounts. This is terrific but not what we need.
We are not looking for "select * from syslogins"