Query for database Accessfor aUser Group??

• IN_Sandeep

  SSCertifiable

  Points: 6259

  More actions

  June 5, 2008 at 7:09 am

  #186520

  hi Friends,

  I have a Quick requirements..

  I have a User group and I need to know what are the database are accessible to this user group??

  Now i am able to know what is the command for a single user by using this following query but I need for a particular user group??

  Query:

  ------------

  SELECT [Name] as DatabaseName from master.dbo.sysdatabases

  WHERE ISNULL(HAS_DBACCESS ([Name]),0)=1

  ORDER BY [Name]

  Please Tell me the Sql Query for this??

  Cheers!

  Sandy.

  --

• IN_Sandeep

  SSCertifiable

  Points: 6259

  More actions

  June 5, 2008 at 8:37 am

  #824844

  Hi All,

  I got a quick solution for this.

  Cheers!

  Sandy.

  --