Access Security or SQL Server Security?

[hooi]

Once an Access application has been upsized to SQL Server, should I continue to use Access' mdw security file or should I use SQL Server's security? I'm new to SQL Server, where should I begin to learn about authentication in SQL Server?

Thanks...

 

[hi there]

i believe you must use SQL server security because you are no longer using the jet engine. i'm also making the transition to SQL server 2k and running into the same types of questions. if you're using SQL server 2k you can use enterprise manager to create user groups and assign priviledges.

 

[hooi]

Thanks Hi There.

 

[Pat Hartman]

The data may be in SQL server but all the objects are still Jet. If you are using Access security to control access to various database objects, that won't change.

 

[Kevin_S]

hooi -

I would suggest using SQL Server security rather then MS Access (my personal opinion) The reason being is that you can create roles (much like groups) and grant access to all objects in the SQL Server environment and you can also really limit access to certain objects. For example: whereas in MS Access you can grant users write permissions to a certain table in SQL Server you can grant permissions to a certain column in a certain table . So if a specific user group only needs access on one or two fields you don't have to grant them access to the whole thing! Also - you can use pass through queries to capture the users login and role in the front end to do all sorts of manipulation in forms/reports/etc... Furthermore I believe, (and someone please correct if untrue), that SQL Server security is more robust and secure then MS Access...

HTH,
Kev

 

[Pat Hartman]

I would suggest using SQL Server security rather then MS Access (my personal opinion)

- I don't disagree. I was merely pointing out that SQL server security was not going to secure the database objects such as forms and reports and so if that was what hooi was concerned about, his security would not change.

 

[Kevin_S]

I don't disagree. I was merely pointing out ...

My apologies Pat if you thought I was disagreeing with your post - I was actually trying to respond to hooi's original post when he/she asked to forum of their thoughts by giving them my opinion on the subject

Also - I agree with your statement to hooi regarding forms and reports and this is something that I have had to account for myself in my applications as well.

Good luck hooi and if you need more info post back!

HTH,
Kevin