users permission problem with adp front end and sql 2000

[Indra]

Hi There,

I converted our Access database to adp front end and sql 2000 db as
back end. Every things is working fine except user permision. When i
distribute the adp file to our staff they could not able to open some
of the report and form, say permision not given, those form or report
in base on DBO permission. But when i give that user system
administrator permission, they can access all the form and talbe,
report etc. Is there any way they can access all the form, query or
report without system administrator group.

The 2nd problem is how can i asign different permision to differnt
users. I want some of the user to not able to even open the talbe or
query except forms or report and some to have full permission. Write
now every one is able to open and modify the talbe etc. Is there any
way to solve this problems. I wanted to rollout this project with this
week but because of this proble i am really getting stop. Please help
me if there is any information about this.

Thanks in advance.

Indra.

 

[Mary Chipman]

I assume you're using integrated security where each user is
connecting using their Windows login (Integrated Security=SSPI). What
you will need to do is to create either individual logins for those
users, or enable logins for the group (if applicable). You'll then
need to create roles in the database, and map the Windows users/groups
to those roles. Users inherit the permissions granted to the roles.
There's more to it than that, of course. Your best bet is to bone up
on what's involved. Here's where to start, and don't forget SQL Books
Online:
http://www.microsoft.com/sql/techinfo/administration/2000/security/default.asp

--mary