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

From: Itzik Ben-Gan (itzik_at_REMOVETHIS.SolidQualityLearning.com)
Date: 01/19/05 

Date: Wed, 19 Jan 2005 18:06:45 +0200

Galen,

It's sp_grantdbaccess. 

-- 
BG, SQL Server MVP
www.SolidQualityLearning.com
<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

  • Re: restoring dB and login to new server
    ... Tibor Karaszi, SQL Server MVP ... that looks like it would simplify things a bit...but I still need to create the login manually? ... databases between servers by doing a full backup, then restoring on the new ... database, I get an error that the "user or role already exists". ...
    (microsoft.public.sqlserver.tools)
  • 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)
  • 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: 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)