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

From: Keith Kratochvil (sqlguy.back2u_at_comcast.net)
Date: 01/19/05 

Date: Wed, 19 Jan 2005 10:06:11 -0600

I am thinking sp_grantdbaccess 

-- 
Keith
<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

  • 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)
  • Re: prevent developers writting to our SQL DB ?
    ... Then only grant access to the procs and views and deny access directly to ... Abstract this through the use of a database role. ... Looking for a SQL Server replication book? ... How can we employ this in a VB and SQL environment when users need ...
    (microsoft.public.sqlserver.server)
  • 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)
  • Re: Newbie to security
    ... >Use sp_grantdbaccess to grant access to the database. ... >databases when you are new to security. ... >SQL Server Resource Kit - Implementing Security ...
    (microsoft.public.sqlserver.security)
Quantcast