associating front end security with back-end security

associating front end security with back-end security

Post by Mudita Gupt » Fri, 03 Apr 1998 04:00:00

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
can use, to create users and groups and grant those users or groups the
on the menu items which inturn provide the right on the screen accessible
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
Software for Telecom Service Providers
Tel: +91-11-6856452,+91-11-6234664

visit us at


1. App Security - front-end or back-end?

We are migrating an old Foxpro app to VB/SQL Server 7. The original app uses
boolean values stored in a table to enable/disable app functionality
depending on the user.  Certain menu options/command buttons would be
enabled or disabled depending on how a user is set up in via the applicaion.

Would I be better off continuing this approach? I was thinking of logging on
to the server with admin privileges (via code)and just letting the app's
(front end) security model handle what can and can't be done to the
database. All database access/changes will be done via stored procedures.

I would appreciate any comments or advice, as well as links to where I can
find more information on this.


2. custom aggs & topcount perf NG on large dimension

3. Integrating front-end security with back-end

4. Possible cache corruption - please help

5. App Security - front-end or back-end?

6. passing return status from sql server procedure to VB

7. Database Security and VB Front End Security

8. Need to Edit Innitab file in AIX


10. using Access 97 front-end with a SQL2000 back-end

11. Access 2000 Front End Linked to SQL 7 Back End

12. visual front end, sql back end