ADP/SQL Server Security

  • Thread starter Thread starter Stanley
  • Start date Start date
S

Stanley

I am upgrading an Access 2002 app to an ADP. I like the
security features I get from Access, and I would like to
do similar things in SQL Server. I understand how SQL
Server Security restricts access to data.

The question is: how can I stop someone from reaching a
form or clicking a button in an ADP. With Access security
I can test for the user being in a group and giving him an
appropriate message if he is not in that group. How can I
accomplish the same thing in ADP/Server (how can I code a
stored procedure say to give me the group someone is in).
Thanks,
Stan
 
Hello Stanley:
You wrote in conference microsoft.public.access.adp.sqlserver on Thu, 5 Aug
2004 13:49:00 -0700:

S> I am upgrading an Access 2002 app to an ADP. I like the
S> security features I get from Access, and I would like to
S> do similar things in SQL Server. I understand how SQL
S> Server Security restricts access to data.

S> The question is: how can I stop someone from reaching a
S> form or clicking a button in an ADP. With Access security
S> I can test for the user being in a group and giving him an
S> appropriate message if he is not in that group. How can I
S> accomplish the same thing in ADP/Server (how can I code a
S> stored procedure say to give me the group someone is in).

Look for the SQL server function IS_MEMBERa in Bools ONline.


Vadim
 
Back
Top