|
|
Posted by Ajay Rengunthwar on 09/26/71 11:45
If you are looking to restrict access through application You can think
of.....
Application role, which allows you to create a role for your
application and grant only this role the proper rights. This role
requires a separate password authentication before granting the rights
associated with the role. So, the user can log in with his own ID and
password. Make sure in your application, you use the sp_setapprole with
a password that only you and your application know to activate the
proper rights. Although the user will be able to log in to SQL Server
through another tool, he will not be able to access without knowing the
password for the application role.
Hope this helps.
Thanks
Ajay Rengunthwar
MCDBA,MCAD
Navigation:
[Reply to this message]
|