Prevent direct connections
Date: Thu, 25 Mar 2004 13:29:07 -0800
We have an application which connects to a SQL 2000
database using the user's NT login. Access to tables is
controlled by the application. The application also
determins which commands (SELECT, UPDATE, DELETE) they can
execute.
Can I block access that doesn't occur through our
application? Can I block access by host or program (as
seen in master.dbo.sysprocesses)?
I can't block access to tables by login, as that would
prevent the application from working.
Any suggestions?
Thanks!!
Relevant Pages
- Re: Logging in irrespective of database access
... Sysadmin role members have full permissions, ... SQL Server MVP ... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ...
(microsoft.public.sqlserver.server) - Re: Logging in irrespective of database access
... Sysadmin role members have full permissions, ... SQL Server MVP ... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ...
(microsoft.public.sqlserver.server) - Re: Logging in irrespective of database access
... Sysadmin role members have full permissions, ... SQL Server MVP ... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ...
(microsoft.public.sqlserver.programming) - Re: Logging in irrespective of database access
... Sysadmin role members have full permissions, ... SQL Server MVP ... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ...
(microsoft.public.sqlserver.programming) - Logging in irrespective of the database access settings
... My problem is that in the Login section of Enterprise Manger I have to ... like there used to be in SQL 6.5. ... What's the point in having the Database Access section if the System Admin ... SQL Server MVP ...
(microsoft.public.sqlserver.server) |
|
