by Hello all !
I am working with SQL Server 6.5 and Visual Basic 5.0
I have a screen on the front-end which only an administrator of the
application
can use, to create users and groups and grant those users or groups the
rights
on the menu items which inturn provide the right on the screen accessible
through
the click of menu.
Each of the screen is associated with table, specific columns of tables,
views or
stored procedures.
I want that when a user is granted right on a screen then those rights
should be granted on the
associated table or table columns as well.
This would prevent users from logging on the back-end and making changes in
the respective tables.
I could not understand how to program what tables, procedures or columns
have been used
in a screen and associate them with back-end rights.
Any help would be greatly appreciated.
Thanks in advance.
--
Mudita Gupta
Infozech
Software for Telecom Service Providers
Tel: +91-11-6856452,+91-11-6234664
visit us at http://www.infozech.com