Jim,
I have read the documentaion on sp_helprotect and other related
documentation. I am new to this. How do I impliment this? How do I call
this sp from VB.NET? I am only familiar with calling sp from
SqlDataAdapters for selects, updates, inserts and deletes.
Because I don't know how this works take a shot at a scenarios that
represents what I would like to be able to do;
Scenario:
The user clicks on a button to open a form (which serves Table1). The
code submits the tablename and user name via a sp to SQLS2K and the
permissions that are granted for that user are returned. The code uses
that information to decide whether to allow viewing access, allow read
access, allow edit access.
Though it likely doesn't work exactly like that what tools are there to
achieve my needs? How do I go about it? Can someone direct me to a
discussion on the topic, and example or some kind of direction?
Thank you,
Doug