Re: Permittion to 2 different DB's on same server

From: Dejan Sarka (dejan_please_reply_to_newsgroups.sarka_at_avtenta.si)
Date: 11/03/03

Next message: Michael Shao [MSFT]: "Re: How to deny DBCC SQLPERF(logspace)"
Previous message: Dejan Sarka: "Re: security tools reference"
In reply to: Moshe Foobar: "Permittion to 2 different DB's on same server"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Date: Mon, 3 Nov 2003 13:42:00 +0100

Moshe,

Use Windows authentication. Grant access to the MSDE to Windows accounts
(check the sp_grantlogin system SP) and then use Windows account policies to
constrain the Windows user.

-- 
Dejan Sarka, SQL Server MVP
Please reply only to the newsgroups.
"Moshe Foobar" <minuteman@newmail.net> wrote in message
news:a674a40c.0311020834.69c17c12@posting.google.com...
> Hi,
> I have msde installed on a server computer.
> I have 2 databases.
> I want one of them to permit only connection from the local machine
> (only the computer where the msde was installed).
> The 2nd DB should permit any coonection that knows the password.
>
> Is this possible in MSDE ?
> If not is it possible in other free Database ?
>
> Thanks in advance.

Next message: Michael Shao [MSFT]: "Re: How to deny DBCC SQLPERF(logspace)"
Previous message: Dejan Sarka: "Re: security tools reference"
In reply to: Moshe Foobar: "Permittion to 2 different DB's on same server"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]