📄 user.sql

📁 community server 源码

💻 SQL

字号:

if not exists (select * from master.dbo.syslogins where loginname = N'NT AUTHORITY\NETWORK SERVICE')
exec sp_grantlogin N'NT AUTHORITY\NETWORK SERVICE'
GO
exec sp_grantdbaccess N'NT AUTHORITY\NETWORK SERVICE', N'NT Authority\Network Service'
GO
exec sp_addrolemember N'db_owner', N'NT Authority\Network Service'
GO

declare @AspNetUser nvarchar(50)
set @AspNetUser = @@SERVERNAME + N'\ASPNET'

if not exists (select * from master.dbo.syslogins where loginname = @AspNetUser)
exec sp_grantlogin @AspNetUser
GO

declare @AspNetUser nvarchar(50)
set @AspNetUser = @@SERVERNAME + N'\ASPNET'

exec sp_grantdbaccess @AspNetUser
GO

declare @AspNetUser nvarchar(50)
set @AspNetUser = @@SERVERNAME + N'\ASPNET'

exec sp_addrolemember N'db_owner', @AspNetUser
GO

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -