Showing posts with label logins. Show all posts
Showing posts with label logins. Show all posts

Friday, March 9, 2012

List of Logins

I want to retrieve the list of all logins in the sql server. can anyone
help me in that?Dear Arfan Ameer

Please see help for sysusers and syslogin in online books, sysusers and
syslogin are the tables which help you to get the requisite LIST.

e.g.
user master;
select * from syslogins ;
or
select * from master..syslogins ;

Umm you can make an inner join of syslogins with sysusers to get user
name for that particular login and can do lot of tricks :)

Download Microsot SQL Server 2000 System Table Map from
http://www.dbnest.com/index.php?pag...s&doc=2&dlcat=1

which may help u to understand the system table thing.

:) :) :)
Saghir Taj
MCDBA
www.dbnest.com: The Nest of DB Professionals.|||Dear Arfan Ameer

Please see help for sysusers and syslogin in online books, sysusers and
syslogin are the tables which help you to get the requisite LIST.

e.g.
user master;
select * from syslogins ;
or
select * from master..syslogins ;

Umm you can make an inner join of syslogins with sysusers to get user
name for that particular login and can do lot of tricks :)

Download Microsot SQL Server 2000 System Table Map from
http://www.dbnest.com/index.php?pag...s&doc=2&dlcat=1

which may help u to understand the system table thing.

:) :) :)
Saghir Taj
MCDBA
www.dbnest.com: The Nest of DB Professionals.|||When I followed the link and selected download I got a page not found
error (404). It would appear something has moved or is unavailable.
-- Mark D Powell --|||check again!

www.dbnest.com

Monday, February 20, 2012

List all the logins that have a certain privileges

Hi,
I would like to know how to get all the login names in a server that have a
certain privilege.
Such as I want to get all the logins that have an update privileges to a
table.
Thanks in advance
Frank
Hi,
Have a Look into sysprotects table. You could right a stored procedure to
query the sysprotects table in all the database where
a user have access.
Thanks
Hari
SQL Server MVP
"Frank" <wangping@.lucent.com> wrote in message
news:ehbHb51YFHA.3620@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I would like to know how to get all the login names in a server that have
> a
> certain privilege.
> Such as I want to get all the logins that have an update privileges to a
> table.
> Thanks in advance
> Frank
>
|||While the information is in the sysprotects table, the difficult part is
that you must go through all of the groups that the user is a member of as
well... IF the user has 3 grants on a particular table, but is a member of
a group which is denied to the table, the permission is deny...
Also remember that is the object owners are the same, and the user is denied
to the table, but granted to a view on the table, he can access the table
via the view...
So doing this gets complicated very quickly... I would search for scripts on
the web as well.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Frank" <wangping@.lucent.com> wrote in message
news:ehbHb51YFHA.3620@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I would like to know how to get all the login names in a server that have
> a
> certain privilege.
> Such as I want to get all the logins that have an update privileges to a
> table.
> Thanks in advance
> Frank
>

List all the logins that have a certain privileges

Hi,
I would like to know how to get all the login names in a server that have a
certain privilege.
Such as I want to get all the logins that have an update privileges to a
table.
Thanks in advance
FrankHi,
Have a Look into sysprotects table. You could right a stored procedure to
query the sysprotects table in all the database where
a user have access.
Thanks
Hari
SQL Server MVP
"Frank" <wangping@.lucent.com> wrote in message
news:ehbHb51YFHA.3620@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I would like to know how to get all the login names in a server that have
> a
> certain privilege.
> Such as I want to get all the logins that have an update privileges to a
> table.
> Thanks in advance
> Frank
>|||While the information is in the sysprotects table, the difficult part is
that you must go through all of the groups that the user is a member of as
well... IF the user has 3 grants on a particular table, but is a member of
a group which is denied to the table, the permission is deny...
Also remember that is the object owners are the same, and the user is denied
to the table, but granted to a view on the table, he can access the table
via the view...
So doing this gets complicated very quickly... I would search for scripts on
the web as well.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Frank" <wangping@.lucent.com> wrote in message
news:ehbHb51YFHA.3620@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I would like to know how to get all the login names in a server that have
> a
> certain privilege.
> Such as I want to get all the logins that have an update privileges to a
> table.
> Thanks in advance
> Frank
>

List all the logins that have a certain privileges

Hi,
I would like to know how to get all the login names in a server that have a
certain privilege.
Such as I want to get all the logins that have an update privileges to a
table.
Thanks in advance
FrankHi,
Have a Look into sysprotects table. You could right a stored procedure to
query the sysprotects table in all the database where
a user have access.
Thanks
Hari
SQL Server MVP
"Frank" <wangping@.lucent.com> wrote in message
news:ehbHb51YFHA.3620@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I would like to know how to get all the login names in a server that have
> a
> certain privilege.
> Such as I want to get all the logins that have an update privileges to a
> table.
> Thanks in advance
> Frank
>|||While the information is in the sysprotects table, the difficult part is
that you must go through all of the groups that the user is a member of as
well... IF the user has 3 grants on a particular table, but is a member of
a group which is denied to the table, the permission is deny...
Also remember that is the object owners are the same, and the user is denied
to the table, but granted to a view on the table, he can access the table
via the view...
So doing this gets complicated very quickly... I would search for scripts on
the web as well.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Frank" <wangping@.lucent.com> wrote in message
news:ehbHb51YFHA.3620@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I would like to know how to get all the login names in a server that have
> a
> certain privilege.
> Such as I want to get all the logins that have an update privileges to a
> table.
> Thanks in advance
> Frank
>

Lis of all logins?

Hello. Does anyone know if there is a way to get a list of all of the
security logins for SQL Server 2000? I need to get a list of all our db
user names on our sql server and was wondering if there was a system stored
procedure in the master db or so that can do this.
Thanks in advance.
JExecute the below command.
sp_helplogins
Thanks
Hari
SQL Server MVP
"J" <IDontLikeSpam@.Nowhere.com> wrote in message
news:OhoVuZS2GHA.4312@.TK2MSFTNGP02.phx.gbl...
> Hello. Does anyone know if there is a way to get a list of all of the
> security logins for SQL Server 2000? I need to get a list of all our db
> user names on our sql server and was wondering if there was a system
> stored procedure in the master db or so that can do this.
> Thanks in advance.
> J
>|||Thanks Hari. I appreciate it.
Take care.

"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:urcuKsS2GHA.1256@.TK2MSFTNGP02.phx.gbl...
> Execute the below command.
> sp_helplogins
> Thanks
> Hari
> SQL Server MVP
> "J" <IDontLikeSpam@.Nowhere.com> wrote in message
> news:OhoVuZS2GHA.4312@.TK2MSFTNGP02.phx.gbl...
>