MSSQL User Permissions

MSSQL User Permissions

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


Hi

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.

TIA

Dan
 
 
 

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.

Regards,
Dmitry

--
Dmitry Arefiev, gs-soft Company, community.gs-soft.com
Personal - www.da-soft.com

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