Re: Granting access for a database to an already created login?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Francesco Anti (_at_)
Date: 01/19/05 

Date: Wed, 19 Jan 2005 17:13:37 +0100

sp_grantdbaccess?

Francesco Anti

<galenboyerdev@hotpop.com> wrote in message news:4qhdwgjg.fsf@hotpop.com...
> I'm trying to grant access for a particular database to an already
> created login.
>
> In enterprise Manager, I can double-click on the login, Hit the
> "Database Access" tab and check the particular database I want to
> grant access to. Does anybody know the particular command which would
> accomplish that?
>
> --
> Galen Boyer

Relevant Pages

  • Multiple Login using same user in a DB
    ... - I have a database MY_DB ... connecting with trusted or explicit connexion. ... In fact once I create the first login and I grant access to the DB, ...
    (microsoft.public.sqlserver.security)
  • Re: cant connect
    ... For the GRANT access i 've use osql syntax but it return a message as Wrong ... i can't login using the 'sa' account from other machine. ... >> can connect to msde without problem on this computer. ...
    (microsoft.public.sqlserver.msde)
  • Re: Granting access for a database to an already created login?
    ... BG, SQL Server MVP ... > I'm trying to grant access for a particular database to an already ... > created login. ...
    (microsoft.public.sqlserver.programming)
  • Re: Granting access for a database to an already created login?
    ... > I'm trying to grant access for a particular database to an already ... > created login. ... > In enterprise Manager, I can double-click on the login, Hit the ...
    (microsoft.public.sqlserver.programming)
  • Granting access for a database to an already created login?
    ... I'm trying to grant access for a particular database to an already ... In enterprise Manager, I can double-click on the login, Hit the ...
    (microsoft.public.sqlserver.programming)