Having not really used SQL200 Enterprise Manager in anger I now have a few
questions about how the user permissions work....

I have an application that has sensitive data stored in a "sensitive table"
I want this data to only be available to the chosen few.
Ideally I want the user to login to access this data once its known that
they are trying to do so. (I don't want the user to login until they wat
sensitive data)
Can I make this happen by setting roles & permissions in the SQL database?
Is this the correct way to do it?
Is this secure?

In the past I have done this (in MS Access) by having a user table with all
the user names and permissions in but each user logged in at the begining
of the application. (most of this data will be public facing on the net so
I don't want login for everyone just those that need access to sensitive
data)

Ahhhhhh Help!

Regards - Paul




*************************************************************************************************
The information contained within this e-mail sent by Birmingham City Council is 
confidential and is intended for the named recipient only. If you are not the intended 
recipient please notify us by telephone immediately on +(44) 121 303 6666 
(International) or return it to us by e-mail quoting the name of the sender and the 
addressee.
*************************************************************************************************


-- 
** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/

To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]

Reply via email to