CODEWITHSUNDEEP
sqldotnetnuke
Rya
Rya

Reputation: 321

DNN - Add or create a Role in DotNetNuke with SQL

I need to add a new DNN role in SQL.

If I add a new record to the dbo.roles table, it does not seem to create the role in the Security Roles page

domain.com/Admin/SecurityRoles.aspx

I tried a INSERT command into dbo.Roles and also the AddRole stored procedure.

Upvotes: 0

Views: 527

Answers (1)

Chris Hammond
Chris Hammond

Reputation: 8943

Adding records through SQL is typically not recommended, it would be better off using the RoleController and the API in DNN.

That being said, you might just need to clear the Cache on your site after doing it in SQL to get the roles populated.

Upvotes: 1

Related Questions