Re: Databaseaccess
From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 02/17/04
- Next message: Dan Guzman: "Re: Application role to access xp_cmdshell"
- Previous message: Carl Olsson: "Application role to access xp_cmdshell"
- In reply to: Daniel Rakojevic: "Re: Databaseaccess"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Tue, 17 Feb 2004 08:53:38 -0500
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 > > >-----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... > >> 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 > > > > > >. > >
- Next message: Dan Guzman: "Re: Application role to access xp_cmdshell"
- Previous message: Carl Olsson: "Application role to access xp_cmdshell"
- In reply to: Daniel Rakojevic: "Re: Databaseaccess"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
