USE [SERP]
GO
IF EXISTS (SELECT * FROM sys.database_principals WHERE name = N'serp')
DROP USER [serp]
GO
USE [master]
GO
CREATE LOGIN [serp]
WITH PASSWORD=N'*******',
DEFAULT_DATABASE=[SERP],
CHECK_EXPIRATION=OFF,
CHECK_POLICY=OFF
GO
EXEC master..sp_addsrvrolemember @loginame = N'serp', @rolename = N'bulkadmin'
GOUSE [SERP]
GO
CREATE USER [serp] FOR LOGIN [serp]
ALTER USER [serp] WITH DEFAULT_SCHEMA=[serp]
EXEC sp_addrolemember N'db_owner', N'serp'
GO刚学SQL,现在有一个上面的命令,不知道是什么意思?请高手给讲解一下。不胜感激!!!
GO
IF EXISTS (SELECT * FROM sys.database_principals WHERE name = N'serp')
DROP USER [serp]
GO
USE [master]
GO
CREATE LOGIN [serp]
WITH PASSWORD=N'*******',
DEFAULT_DATABASE=[SERP],
CHECK_EXPIRATION=OFF,
CHECK_POLICY=OFF
GO
EXEC master..sp_addsrvrolemember @loginame = N'serp', @rolename = N'bulkadmin'
GOUSE [SERP]
GO
CREATE USER [serp] FOR LOGIN [serp]
ALTER USER [serp] WITH DEFAULT_SCHEMA=[serp]
EXEC sp_addrolemember N'db_owner', N'serp'
GO刚学SQL,现在有一个上面的命令,不知道是什么意思?请高手给讲解一下。不胜感激!!!
create user 创建用户,与该登陆进行信任链接
CREATE USER [serp] FOR LOGIN [serp] ----创建新用户
ALTER USER [serp] WITH DEFAULT_SCHEMA=[serp] -----修改用户默认模式
EXEC sp_addrolemember N'db_owner', N'serp' ---设定用户角色
GO
GO
IF EXISTS (SELECT * FROM sys.database_principals WHERE name = N'serp')
DROP USER [serp]
GO
USE [master] --创建登录用户
GO
CREATE LOGIN [serp]
WITH PASSWORD=N'*******',
DEFAULT_DATABASE=[SERP],
CHECK_EXPIRATION=OFF,
CHECK_POLICY=OFF
GO
EXEC master..sp_addsrvrolemember @loginame = N'serp', @rolename = N'bulkadmin'
GO USE [SERP] --修改默认架构,角色
GO
CREATE USER [serp] FOR LOGIN [serp]
ALTER USER [serp] WITH DEFAULT_SCHEMA=[serp]
EXEC sp_addrolemember N'db_owner', N'serp'
GO
可是用它这些SQL命令后,就可以正常运行,所以我想知道这些SQL命令是不是有我不知道的东西。