摘要:
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)