Re: Databaseaccess

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 02/16/04


Date: Mon, 16 Feb 2004 13:17:36 -0500

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


Relevant Pages

  • Re: Logging in irrespective of database access
    ... Try connecting using Query Analyzer with one of the problem logins and run ... the following in the context of your demodata and accounts databases: ... This will return the security context used to access the database. ... SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: Logging in irrespective of database access
    ... Try connecting using Query Analyzer with one of the problem logins and run ... the following in the context of your demodata and accounts databases: ... This will return the security context used to access the database. ... SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Changing security authentication type.
    ... i'm thinking that yes in time the sa account ... A new DBA Admin User login would only be useful for SQL Login purposes. ... if appropriate you can add users to the db_owner role in a database. ... Create one or more logins for the applications. ...
    (microsoft.public.sqlserver.security)
  • Re: Help Ive been an idiot
    ... You need to make sure that you readd any logins that were mapped to database ... Jasper Smith (SQL Server MVP) ... > connectionString, CommandType commandType, String commandText, ...
    (microsoft.public.sqlserver.setup)
  • RE: Creating a DB User *not* on current Machine
    ... detach/attach the database to a new server. ... Server.When you move a database from one server that is running SQL Server ... the security identification numbers of the logins in the master ...
    (microsoft.public.sqlserver.security)