new user - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

new user

Author

Topic

mike009
Starting Member

15 Posts

Posted - 2006-03-30 : 14:48:28

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

Srinika
Master Smack Fu Yak Hacker

1378 Posts

Posted - 2006-03-30 : 15:22:56

Hi Mike,

If u r OK with creating users using Enterprise Manager, I can help.

Goto EM
--> SQL Server Instance
--> Security
--> Logins
--> <Right Panel> Right Click
--> New Login
--> Provide SQL Server Authentication + Password, Default DB, Server Roles, DB Roles
Done

Srinika

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources