Re: SQL Server Security
From: Hari (hari_prasad_k_at_hotmail.com)
Date: 03/31/04
- Next message: Lucio: "Re: Protecting database from administrators"
- Previous message: tony c: "SQL Server Security"
- In reply to: tony c: "SQL Server Security"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 31 Mar 2004 17:26:30 +0530
Hi,
Did you meant to control the SQL server access using
application not using Query analyzer or Enterprise manager.
Then create the application roles and assign it to user. The user will get
access only if the application role password is enabled.
Check books online on setting Application roles.
Thanks
Hari
MCDBA
"tony c" <tony.chorleyRUBBISH@mcalpineplc.com> wrote in message
news:1680901c41712$e6773a00$a101280a@phx.gbl...
> Is there a method of only allowing users to access SQL
> Server Databases USING SPECIFIED APPLICATIONS/DATABASES?
- Next message: Lucio: "Re: Protecting database from administrators"
- Previous message: tony c: "SQL Server Security"
- In reply to: tony c: "SQL Server Security"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
