Saturday, February 25, 2012

Need Urgent Help...............

Hi i am manish,working wth sql server2000
Need Urgent Help............
Currently,we are preparing our one software,
I want to enfore some security check ,so that user of that software not able
to watch what kind of data that software contains
security i need for that
1) application level: no other external software are allowed
2)default Windows NT groups are to be disable
3) user should able to execute any kind select ,etc query
Regards
ManishHave a look at Application Roles in BOL. By activating an application role
from your application and by only granting permissions to that application
role, you should be able to get the behaviour you require
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Manish Mokadam" <manish.mokadam@.honeywell.com> wrote in message
news:471E447A-D6B2-4361-8814-AF59362FA34D@.microsoft.com...
> Hi i am manish,working wth sql server2000
> Need Urgent Help............
> Currently,we are preparing our one software,
> I want to enfore some security check ,so that user of that software not
able to watch what kind of data that software contains
> security i need for that
> 1) application level: no other external software are allowed
> 2)default Windows NT groups are to be disable
> 3) user should able to execute any kind select ,etc query
>
> Regards
> Manish

No comments:

Post a Comment