MSSQL User Permissions

MSSQL User Permissions

Post by Dan » Thu, 13 Nov 2003 18:37:42


I am connecting to a MSSQL database from my Delphi 5 application using the
BDE (I know, I know but the apparantly the budget doesn't stretch far enough
to convert the application to ADO!).

When I open the database, I would like to check what rights the SQL database
user has to some system tables - In this case I wish to check if the user
has Insert, Update and Delete rights to the sysusers table.

Any help would be greatly appreciated.



MSSQL User Permissions

Post by Dmitry Are » Fri, 14 Nov 2003 16:42:12

Hello !

To get table provileges use SP_TABLE_PRIVILEGES
stored proc in Master DB.


Dmitry Arefiev, gs-soft Company,
Personal -

SAPx - Delphi to SAP R/3 direct access
Saphir - SAP R/3 metadata on your fingertips
MetaBase - ERWIN model in Delphi applications
NCOCI8 - Freeware Delphi to ORACLE direct access