Database Form security

S

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
 
W

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.
 
W

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top