How do I detect col-level security prior to opening table

Create a view for the fields the user can access and use the view
You can probably create different views for the different groups in
the database.  Based on the group the user belongs to, you can
use the appropriate view to query.


Darryl Booth wrote:

>  Hi All:

> If a user is secured from querying one col on a table, how do I detect this
> prior to attempting to open the query/table?  If I open the table without
> this knowledge, it errors.

> I figure that If I know which col the user may not see, I can avoid it in my
> query.

H.S. Prasad                                     Standard Disclaimer
Phone: (302)634-8398
Fax  : (302)634-8563