How to set up security roles?????

[Mayo123]

I have Access as FE, and SQL server as BE via ODBC. The tables are all linked. The server is using SQL server Authentications. In my Access form load event, I will check each user’s NT id to make sure if it’s matching the id of Usertable at BE, if not, a msgbox will say sth llike“You’re not authorized”. So literally users have no login form. But now we need to give some users read-only permissions(some can insert or update), How can I limit them??
Thanks for your time and help!

 

[jbenson001]

you can set up roles in SQL Server using Enterpise Manager or you can set permissions at the table level.

jim

 

[danvlas]

BOL (Books On Line) would be a good start.
Create decision-making groups. Add users to groups. Add right to groups. That should be it...

HTH


Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[Mayo123]

but if I set up roles in SQL server, my users have to log in to get connected to the server, am I right?

 

[jbenson001]

I am not sure how Access works, probably better to ask this in the Access forum. If you are using linked tables, the rights should translate down, but I am not sure if by linking the tables you set a login and pw there.

Jim

 

[Mayo123]

HTH, it sounds like what I did before, set up group permissions from FE.

 

[danvlas]

of course. who ever is not an user, has no right to connect to sql.





Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html