Hi,
how it is possible to make a limition of access to a
database ?
I want that the database is only accessible from only one
other database !
Greetings,
Daniel RakojevicYou limit access by assigning rights to Logins. If you don't want anyone to
have access then don't give them a Login or password and they won't be able
to get in.
Andrew J. Kelly
SQL Server MVP
"Daniel Rakojevic" <anonymous@.discussions.microsoft.com> wrote in message
news:113cb01c3f4a6$9f16dcd0$a601280a@.phx
.gbl...
> Hi,
> how it is possible to make a limition of access to a
> database ?
> I want that the database is only accessible from only one
> other database !
> Greetings,
> Daniel Rakojevic|||Thanks,
i have an internet application and my user is iusr_daniel.
For the hidden database, i need now a new user ?
How to make it, with an new user ?
Greetings,
Daniel
>--Original Message--
>You limit access by assigning rights to Logins. If you
don't want anyone to
>have access then don't give them a Login or password and
they won't be able
>to get in.
>
>--
>Andrew J. Kelly
>SQL Server MVP
>
>"Daniel Rakojevic" <anonymous@.discussions.microsoft.com>
wrote in message
> news:113cb01c3f4a6$9f16dcd0$a601280a@.phx
.gbl...
one
>
>.
>|||If that database is on the same server then just make sure the user from the
other database is a valid user in that one. If you don't add any other
users into the second database then that user should be the only one who can
access it other than sa's.
Andrew J. Kelly
SQL Server MVP
"Daniel Rakojevic" <anonymous@.discussions.microsoft.com> wrote in message
news:10e1401c3f52f$6620cec0$a101280a@.phx
.gbl...
> Thanks,
> i have an internet application and my user is iusr_daniel.
> For the hidden database, i need now a new user ?
> How to make it, with an new user ?
> Greetings,
> Daniel
>
> don't want anyone to
> they won't be able
> wrote in message
> one
