SQL Server security

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello everyone

Does anyone know something about implementing SQL Server security in
MSAccess Project ()adp front-end ?
How to use SQL server DB roles to grant rigts on Forms controls ?

thanks in advance
 
Excerpt if you are willing to go into some very extensive programming, you
cannot fine tune the security rights for the forms and reports of an ADP
project against SQL-Server. For all practical purposes, the access rights
for the account used in the login (File | Connection) is what you get as the
access rights for all Forms /Controls /Reports.

Of course, you could try things like Application Role to further define the
access rights for each forms /controls /reports; however, if you try to do
this from ADP, probably that you will be hit by an incredible amount of
problems/bugs.

The newsgroup for ADP is m.p.a.adp.sqlserver .
 
Back
Top