sql server新建有并授权, sp_configure命令

一、新建用户并授权

新建帐户appuser，密码为163.com，并允许该用户对appdb数据库的test表有select,insert,update权限，那么依次执行
exec sp_addlogin 'appuser','163.com','TEST'
go

use TEST
exec sp_grantdbaccess 'appuser'
go

use TEST
grant select,insert,update
on test
to appuser
go

 

---如果还要添加角色db_owner,  那么

USE test;
exec sp_addrolemember 'db_owner', 'test'
go

 

二、sp_configure命令

-- To allow advanced options to be changed.
EXEC sp_configure 'show advanced options', 1
GO
-- To update the currently configured value for advanced options.
RECONFIGURE
GO
-- To enable the feature.
EXEC sp_configure 'xp_cmdshell', 1
GO
-- To update the currently configured value for this feature.
RECONFIGURE
GO

EXEC sp_configure 'xp_cmdshell', 1
GO

EXEC master..xp_cmdshell 'bcp "SELECT top 10 * FROM RMF.dbo.admin" queryout "d:\1.txt" -c -t \t -S"localhost\sqlexpress" -U"sa" -P"12345" '