how to create a user by script with as administrator of my database?

Pls try this-

NewUserName

Use [YourDBName]
GO

IF NOT EXISTS (SELECT TOP 1 1 FROM SYS.DATABASE_PRINCIPALS WHERE name = N'NewUserName')
BEGIN
    CREATE USER [NewUserName] FOR LOGIN [NewUserName]
    EXEC sp_addrolemember N'db_owner', N'[NewUserName]'
	
END
GO

Select allOpen in new window

You can also grant permissions if required.

Hello Pawan

I did this:

USE [master]
GO
CREATE LOGIN [alexhaifa] WITH PASSWORD=N'aqz1973', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
EXEC master..sp_addsrvrolemember @loginame = N'alexhaifa', @rolename = N'sysadmin'
GO
USE [SAAS_05091973_HERMES_ALEXHAIFA]
GO
CREATE USER [alexhaifa] FOR LOGIN [alexhaifa]
GO


When I login in my database with my created login, I noticed that I have access with all databases, I only want to have access to this:

SAAS_05091973_HERMES_ALEXHAIFA

where should I change?  Default Database?

Change USE [master] to USE [SAAS_05091973_HERMES_ALEXHAIFA] and then try.

You can use this to drop the user -

EXEC sp_dropuser 'UserName'

I did that, my default database = [SAAS_05091973_HERMES_ALEXHAIFA]

But when I login on the sql, I can open all database and not only [SAAS_05091973_HERMES_ALEXHAIFA] :(

nope :(

Thanks a lot