www.webdeveloper.com
Results 1 to 2 of 2

Thread: new user

  1. #1
    Join Date
    Mar 2006
    Posts
    8

    new user

    hi all

    in ms sql server

    how can i create db useer?

    if i follow the steps in book online i get errors

    my databas name is "myTestBD"

    CREATE LOGIN mike
    WITH PASSWORD = '123456';
    USE myTestBD;
    CREATE USER mike;
    GO

    error is
    Msg 170, Level 15, State 1, Line 2
    Line 2: Incorrect syntax near 'LOGIN'.
    Msg 156, Level 15, State 1, Line 5
    Incorrect syntax near the keyword 'USER'

    any idea

    do you know how to create users in(DERBY or Cloudscap or DB2)
    thx

  2. #2
    Join Date
    Feb 2006
    Posts
    520
    In Enterprise Manager for MS SQL right click on database, select New >> Database User

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles