Wednesday, September 08, 2010

View Article

26

Dưới đây là đoạn script chuyển quyền của DNN user bình thường thành 1 user có quyền host.

DECLARE @username varchar(50)

SET @username = 'username_muon_doi'

UPDATE 
   
Users 
SET 
   
IsSuperUser = 1 
WHERE 
   
username = @username

DELETE FROM 
   
UserPortals 
WHERE 
   
UserId = 
   
(SELECT UserID 
   
FROM Users 
   
WHERE username = @username)

 

Link chi tiết: http://dnnuke.blogspot.com/2008/11/how-to-promote-regular-dotnetnuke-user.html?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+DotnetnukeThem+%28DotNetNuke+them!%29&utm_content=FeedBurner

Tags: DNN, script
Posted in: Tips

Comments

There are currently no comments, be the first to post one.

Post Comment

Name (required)

Email (required)

Website

HomeTrangITForum
Copyright 2010 by Nguyễn Minh ĐứcDesigned by DyNNamiteTerms Of UsePrivacy Statement