一些权限的信息1 --分配整表权限 GRANT SELECT , INSERT , UPDATE , DELETE ON table1 TO [用户名] --分配权限到具体的列 GRANT SELECT , UPDATE ON table1(id,AA) TO [用户名]2 --syspermissions 每个数据库 权限
Why do not create a login and assign to special user? Limitted sa will take some matter in maintenance work, right?
--分配整表权限
GRANT SELECT , INSERT , UPDATE , DELETE ON table1 TO [用户名] --分配权限到具体的列
GRANT SELECT , UPDATE ON table1(id,AA) TO [用户名]2
--syspermissions 每个数据库 权限
Limitted sa will take some matter in maintenance work, right?