determine SQLS2K table level permission for a user

[dbuchanan]

Is it possible to verify SQLS2K table level permissions from VB.NET for
the logged in user.
(query SQL Server 2000 some how.)


I want to be able to deny viewing or deny editing in a form based on
the permissions for a particular user and the table.


Can anyone direct me to example code for this?


Thank you,


Doug

 

[Jim Hughes]

Is it possible to verify SQLS2K table level permissions from VB.NET for
the logged in user.
(query SQL Server 2000 some how.)


I want to be able to deny viewing or deny editing in a form based on
the permissions for a particular user and the table.


Can anyone direct me to example code for this?

Look at the SQL Books On LIne for sp_helprotect

 

[dbuchanan]

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