Database Form security

[steel]

Hi,

I have a fairly large adp project, but now I need to apply some Form-level
security. There are 4 SQL Groups with a User connecting to SQL via
NT-security. Is it best to use SQL to stop user access to Views or to create
new views with limited data for each Group.

My problem is that my adp Forms have all fields present, whereas applying
the new security Groups some of the Forms fields are now sensitive. I guess I
can look at vba to check login and hide fields that they shouldn't see, but I
think this will be very time consuming.

The only option, i can see, is to create duplicate sql Views (not showing
sensitive data) and apply SQL security to each View.

Is this the best way to do this or do I have my 'blinkers' on.

Thanks.

Alan

 

[Wei Lu]

Hi Alan,

Welcome to use MSDN Managed Newsgroup Support.

From your description, my understanding of this issue is: You want to
control users to access the SQL View to showing the only data they have
permission to see. If i misunderstood your concern, please feel free to
point it out.

Based on your scenario, I think you still need to use the VBA to control
what the SQL View the user could access. SQL Server can not control which
rows the user could access directly.




Wei Lu
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
=====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[steel]

Hi Wei,

I was doing some searching on the Internet and I found a product that seems
to do what I am after.

http://www.databasecreations.com/prod_apsm.htm

Have you heard of this product before? It would be great if Microsoft had a
similar tool. Do you know of an alternative?

Thanks.

 

[Wei Lu]

Hi steel,

I have no experience on this product before.

Since this is a third-party product that I can not provide any advise on it.

Based on my research, i didn't find a similar tool in our Products.

You may submit feedback on this via the link below to improve our product.
http://lab.msdn.microsoft.com/productfeedback/default.aspx

Thanks!

Wei Lu
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
=====================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.