- ---指定指定用户授权访问指定表
exec sp_addrole 'seeview' - GRANT SELECT ON View_RunningData TO seeview
- exec sp_addlogin 'yhsjjk','yh123','DA_Dev517'
- exec sp_adduser 'yhsjjk','yh123','seeview'
修改用户名
ALTER LOGIN SA WITH NAME = ‘新用户名’
修改密码
ALTER LOGIN SA WITH PASSWORD = ‘新密码’
