OK folks, I have had sysadmin permissions, so I should be able to list all db_users...to prove it to myself that sysadmin is good enough,I have just created a sql...

Thank you!!!!!!

As I said, I don't know who the other users are so I can't alter permissions on user.

Any link will be appreciated. I would like to be clearly...

I will tell my dba. if you just show me a link where I can read about it I will be happy. Please enjoy your time with your...

I suspected as much. No,I am not the dba but I talked to the dba. The dba doesn't know. The dba gave me this task.

Lynn, would you please not reply if you don't have an answer? I am looking for an answer to the question of how to search system tables or views...

correct. I see my own, I see a few other people's, some windows usernames, and I used to think that was all of them until I read this article...

http://msdn.microsoft.com/en-us/library/ms187328.aspx

where...

I debated keeping it to same thread. Only I will use it to produce a list and ultimately a report. Whether someone will ask me to run it...

Better yet, Lynn, if you have a diagram that contains views and how they're related to system tables, post it!

OK, thank you very much.

OK, it seems to me that SQL DB security is a beast to be understood before one attempts this kind of inventory. That sys table alone, is a hilarious...

back to second part of original question. Can you also point me to resource for retrieving list of permissions by user?

well, isn't that brilliant! Thank you for helping me see that.

OK. First I made typo. I should have typed

For server logins I run:

SELECT name, type, type_desc

FROM sys.server_principals

For database users I run:

SELECT...

Thanks for clarification of terms. Logins = Server, Users = Database. Object Explorer complicates the issue itself, but referring to 'Logins' under Database->Security->Logins....which you say is USERS actually....