新建查询
查询全部的表
select * from sysobjects where xtype='U'
存储过程标量
select * from sysobjects where xtype='P '
函数
select * from sysobjects where xtype='FN'
视图
select * from sysobjects where xtype='V'
1、创建用户
CREATE LOGIN developer
WITH PASSWORD = '强密码',
default_database= test;
2、加入用户角色,登录名映射数据库用户
create user developer for login developer
use test;
go
EXEC sp_change_users_login 'Update_One', 'developer', 'developer';
go
3、分配权限,创建存储过程,利用grant给全部的权限,利用deny限制权限
4、创建存储过程例子
create procedure viewProce
as
begin
SELECT
'deny INSERT,VIEW DEFINITION,ALTER,UPDATE, TAKE OWNERSHIP,CONTROL,DELETE,SELECT,REFERE