Creating a user without any password

[manmaria]

Can I create a user without any password? This user is going to own the schema but we never going to login as this user. This user is not belongs to any windows account

TIA

 

[bborissov]

WHY?

USE [master]
GO
CREATE LOGIN [testme] WITH PASSWORD=N'', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO

But tell me when you create your user (I don't want the name) and what is the IP of your SQL Server and see what could happens

You never going to login as this user but somebody could
and that is NOT a good idea at all.

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[manmaria]

Thanks Borislav. Probably what I need is a schema and create all the tables under that schema rather using the default dbo. Any draw backs?
TIA

 

[bborissov]

Sorry, my fault (Friday night, you know)
You ask for User not for Login!!!!
Grrrrr!
You can create user (user don't have password)
Check CREATE USER in BOL.

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.