Obtaining a List of Users and Groups from SQL Server using ADO

Hello

   You can get list users of Users with using folloving sql:

   SELECT name FROM sysusers WHERE issqluser=1

Permissions :

SELECT PERMISSIONS(OBJECT_ID(NameYourTable)) as CodePerm

This is tru if you use MS SQL Server.

Yours sincerely
Vladimir Lubenchenko
mailto:vlad_lubenche...@yahoo.com
ICQ: 53906951

Quote
"Michael Dillon" <M...@dillon16.freeserve.co.uk> wrote in message

news:97gos6$hjk$1@newsg2.svr.pol.co.uk...
Quote
> Hi

> Does anyone know a decent way of obtaining a list of Users, groups and
their
> permissions from SQL Server using ADO.

> I know ADOX has this functionality but it is not yet compatible with the
Sql
> Server OLE DB provider.

> Any help is greatly appreciated.

> Michael