Re: Adding a database user

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 05/29/04 

Date: Sat, 29 May 2004 09:39:10 +0530

Hi,

Also have a look into the system procedures which allocate fixed roles to
users/logins in books online.

sp_addsrvrolemember and sp_addrolemember

Thanks
Hari
MCDBA

"Andrew J. Kelly" <sqlmvpnooospam@shadhawk.com> wrote in message
news:ORPqt3OREHA.3012@tk2msftngp13.phx.gbl...
> Steve,
>
> Do you mean a User or a Login or both? There is a difference and a User
is
> no good without an associated Login. You may want to check out sp_adduser
> and sp_addlogin in BooksOnLine.
>
> --
>
> Andrew J. Kelly
> SQL Server MVP
>
>
> "Steve Caliendo" <scaliendo@epion.com> wrote in message
> news:e4Rvg8NREHA.1308@TK2MSFTNGP10.phx.gbl...
> > Hi,
> >
> > Could someone please tell me how to add a database user using a query?
I
> > know how to set the appropriate permissions for tables of existing
users,
> > but I can't figure out how to add a new user.
> >
> > Thank you,
> >
> > Steve
> >
> >
>
>

Relevant Pages

  • Re: Where is the user login name & password stored?
    ... --- Steve ... Can the entire area be cleared, similar to clearing reccent document ... login gets remembered, and if I have made a typo that gets remembered, ...
    (microsoft.public.windowsxp.security_admin)
  • Re: W2k3 Shared Folder help
    ... Steve ... > DHCP setup), I also have a clean setup of a PC with Windows XP Pro, I can ... > If I login on the Server I have full access. ...
    (microsoft.public.win2000.networking)
  • Re: HOW TO HANDLE CONTROL_LOGOFF_EVENT handler in JAVA
    ... It needs to be restarted manually again after a login. ... > urgent, and I am currently at my wits end,so any help would be greatly ... finding a suitable solution. ... Steve W. Jackson ...
    (comp.lang.java.help)
  • Re: XP: Cool feature with a weakness
    ... orientation of the computer screen image" to be considered an ""XP ... Steve... ... how it is bad to have user video settings effect the login ... Macs are Macs and Apple is still making and selling Macs ...
    (comp.sys.mac.advocacy)
  • RE: automatically generating an encrypted passwd for useradd -p
    ... On Tue, 2003-12-02 at 08:35, Rigler, Steve wrote: ... > next login or to automatically set the password to something? ...
    (RedHat)