getting list of users who have access to db

microsoft.public.sqlserver.programming

18 Aug 2005 4:33 PM

Brian Henry

What is the procedure for getting a list of users that have rights to access
a database? I'd like to get a listing back of anyone who has any rights to a
specific db (sorry still learning the backend dbo type commands in sql
server)

also any good articles on security permission settings i could look at to
make sure I am starting to learn these correctly? thanks!

18 Aug 2005 10:50 PM

Brian,

Do 'sp_helpuser' to get a list of users for the current database.

I also suggest you take a look at this article, especially the security
section.
http://msdn.microsoft.com/library/en-us/tsqlref/ts_sp_00_519s.asp

--
-oj

Show quote

"Brian Henry" <nospam@newsgroups.microsoft> wrote in message
news:%23G25XKBpFHA.3408@tk2msftngp13.phx.gbl...
> What is the procedure for getting a list of users that have rights to
> access a database? I'd like to get a listing back of anyone who has any
> rights to a specific db (sorry still learning the backend dbo type
> commands in sql server)
>
> also any good articles on security permission settings i could look at to
> make sure I am starting to learn these correctly? thanks!
>