Re: Script to retrieve database security




I assume it's a SQL Server 2005. Answers inline.

--
Ekrem Önsoy



"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

select * from sys.syslogins

select * from sys.sysusers

These may work for you.


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


You can use SSIS to transfer your logins from one SQL Server to another.

For more information about SSIS:
http://msdn2.microsoft.com/en-us/library/ms141026.aspx


Thanks,

.



Relevant Pages

  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Problem attaching Northwind traders sample database in SQL Server 2005
    ... "Paul" wrote in message ... the user account that my instance of SQl Server was using didn't have sufficient rights to the file. ... "Ekrem Önsoy" wrote in message ... When I attempt to attach the database I receive an error: ...
    (microsoft.public.sqlserver.setup)
  • Re: Word 2003/Access2000/SQLSVR
    ... SQL server being where the data is held and this is accessed through a MS ... entire database and that may be say a record for Berkshire. ... "Peter Jamieson" wrote: ... replaced with the first record on the table in use. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: MS Access DAO -> ADO.NET Migration
    ... full SQL Server and I see the logic you explained in a multi user ... allow two users to access the same database file Read/Write at any given ... The book was a pleasure to read after the gibberish that Microsoft 'puts ... Hitchhiker's Guide to Visual Studio and SQL Server ...
    (microsoft.public.dotnet.framework.adonet)