Hi,
I have need to query the master database to get a list of all databases, and then use a passed-in username to query every database's sysusers table to see if a specific user has permission to access the database. Then, I need to return a recordset to an asp page that contains only the list of databases that the user has access to.
I've been reading tsql tutorials and I think there must be a way to user a Cursor to do this, but can't seem to figure out how.. Any help is greatly appreciated.
Thanks,
Mike
I have need to query the master database to get a list of all databases, and then use a passed-in username to query every database's sysusers table to see if a specific user has permission to access the database. Then, I need to return a recordset to an asp page that contains only the list of databases that the user has access to.
I've been reading tsql tutorials and I think there must be a way to user a Cursor to do this, but can't seem to figure out how.. Any help is greatly appreciated.
Thanks,
Mike