Re: Script to retrieve database security

Also, you can use the stored procedures:

sp_helplogins
sp_helprotect

Sp_helplogins will show all the databases in which a login is a user and
what roles it is a member of. As Erland mentioned, there are many ways to
assign permissions, so this will not get everything.

sp_helprotect will show rights specifically assigned within a database, but
will not get some of the new 2005 features.

RLF

"qjlee" <qjlee@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:65F2970E-D890-47EC-A5F4-D936EAF00C56@xxxxxxxxxxxxxxxx
Hi,

I have two questions:

1). Is there anyway I can retrieve what sql login has access to what
database and have what kind of access to each database

2). If I want to transfer a sql account from one domain to another. what
would be the best practice?

Thanks,


.

Relevant Pages

  • Re: PDO: Switch database user without reopening connection
    ... At the bare minimum there will be a login user who only has ... modifications to the database as well (editors get update permission, ... As database connections are expensive to ... a certain visitor in the Session, and use that value to start the right ...
    (comp.lang.php)
  • Connecting a user from a backup database to a new login
    ... In SQL Server 2000, I loaded a backup file into a new local database. ... The database has an existing user which owns several stored procedures, ... I want to create a login of the same ...
    (microsoft.public.sqlserver.security)
  • RE: Windows NT Security
    ... Stored Procedures offer an opportunity to improve your database security. ... Make a new login - in my case I'm using MyLogin. ... GRANT EXECUTE ON usp_ins_AUDIT_FIELD TO MyLogin ...
    (microsoft.public.sqlserver.programming)
  • Re: PDO: Switch database user without reopening connection
    ... At the bare minimum there will be a login user who only has ... the postgres user they are logged in as to one that can make ... modifications to the database as well (editors get update permission, ... As database connections are expensive to ...
    (comp.lang.php)
  • RE: How to allow users to change their password?
    ... be set up to provide the Security dialog window for password changes. ... I'll have to login using their login ... > name/password first. ... See http://www.QBuilt.com for all your database needs. ...
    (microsoft.public.access.security)