摘要:
1 CREATE PROCEDURE [dbo].[GetTree] 2 @Id int 3 AS 4 BEGIN 5 with cte as 6 ( 7 select Id,Pid,Name,0 as lvl from Entity 8 where Id = @Id 9 union all 10 ... 阅读全文
posted @ 2017-11-01 23:15
Rick Sun
阅读(1621)评论(0)推荐(0)
摘要:
USE mydata; SELECT s.name FROM sys.schemas s WHERE s.principal_id= USER_ID('developer'); --将db_owner Schema的Owner改为dboALTER AUTHORIZATION on SCHEMA::db_owner TO dbo; ---再次查询用户test6拥有的Schema为空 SELECT s.name FROM sys.schemas s WHERE s.principal_id= USER_ID('developer'); --删除用户test6 DRO 阅读全文
posted @ 2013-05-21 18:39
Rick Sun
阅读(321)评论(0)推荐(0)