Login setting by IP range?

Hello,
In mysql we can set to allow a user to login and access certain
table from certain host, is there anything close to that in MSSQL 2000/2005?
Actually, we just need to control certain users unable to use the
Domain Creditial to access certain databases/tables except in the company's
IP, while we need to make sure for certain databases/tables, the client can
be accessed anywhere.
If not, is there any kind of database connection proxies that we can
use to control the connections, or this there any tutorial on how to relay
database datas so we can write a program to do access check?
Looking forward for reply.
Regards,
Lau Lei CheongLau
How do they (users) access the database? Did you divide them into Groups?
You can DENY access on table for the user .
In addition , you can specify a hostname in connection string.
"Lau Lei Cheong" <leu_lc@.yehoo.com.hk> wrote in message
news:uXz12iGMGHA.3856@.TK2MSFTNGP12.phx.gbl...
> Hello,
> In mysql we can set to allow a user to login and access certain
> table from certain host, is there anything close to that in MSSQL
> 2000/2005?
> Actually, we just need to control certain users unable to use the
> Domain Creditial to access certain databases/tables except in the
> company's IP, while we need to make sure for certain databases/tables, the
> client can be accessed anywhere.
> If not, is there any kind of database connection proxies that we
> can use to control the connections, or this there any tutorial on how to
> relay database datas so we can write a program to do access check?
> Looking forward for reply.
> Regards,
> Lau Lei Cheong
>|||Yes, I know I can divide users into groups but that's not the problem.
The problem is, as the subject line suggested, I can't find way to limit
certain user's access to certain database/table from certain IP.
"Uri Dimant" <urid@.iscar.co.il> glsD:%23aeJm7GMGHA.500@.TK2MSFTNGP15.phx.gbl...[vbc
ol=seagreen]
> Lau
> How do they (users) access the database? Did you divide them into Groups?
> You can DENY access on table for the user .
> In addition , you can specify a hostname in connection string.
>
> "Lau Lei Cheong" <leu_lc@.yehoo.com.hk> wrote in message
> news:uXz12iGMGHA.3856@.TK2MSFTNGP12.phx.gbl...
>[/vbcol]|||Well, have a look at APPLICATION ROLE in the BOL
"Lau Lei Cheong" <leu_lc@.yehoo.com.hk> wrote in message
news:O2MjaNHMGHA.3960@.TK2MSFTNGP09.phx.gbl...
> Yes, I know I can divide users into groups but that's not the problem.
> The problem is, as the subject line suggested, I can't find way to limit
> certain user's access to certain database/table from certain IP.
> "Uri Dimant" <urid@.iscar.co.il>
> glsD:%23aeJm7GMGHA.500@.TK2MSFTNGP15.phx.gbl...
>|||Sorry, I've reviewed application role, but it don't help in this case
because:
1) I need to control access by IP, not by application
2) Some users under the control are application developers who can write
their own application.
But your information is really useful on other area, thanks.
"Uri Dimant" <urid@.iscar.co.il> glsD:%23TPXYYHMGHA.2696@.TK2MSFTNGP14.phx.gbl...[vb
col=seagreen]
> Well, have a look at APPLICATION ROLE in the BOL
> "Lau Lei Cheong" <leu_lc@.yehoo.com.hk> wrote in message
> news:O2MjaNHMGHA.3960@.TK2MSFTNGP09.phx.gbl...
>[/vbcol]