More in this section
Forums / Developing with Sitefinity / Set CmsAccess in database table

Set CmsAccess in database table

The forums are in read-only mode. In case that you want to directly contact the Progress Sitefinity team use the support center. In our Google Plus group you can find more than one thousand Sitefinity developers discussing different topics. For the Stack Overflow threads don’t forget to use the “Sitefinity” tag.
2 posts, 0 answered
  1. Varinder Kumar
    Varinder Kumar avatar
    15 posts
    13 Apr 2010
    01 Aug 2010
    Link to this post
    Hello All,

    I am using the Sitefinty 3.7 version.  I have created one stored procedures which will create pages/users/roles/assigning role to a user/set page permissions on calling that stored procedure and it's working fine like it creates the pages/users/roles/assigning role to a user/set page permissions.

    My problem is when I tried to login into sitefinity by giving user credentials as user name and password (user created by stored procedure), it display the exception as follow:

    Server Error in '/MySite' Application.

    This type of page is not served.

    Description: The type of page you have requested is not served because it has been explicitly forbidden.  The extension '.aspx' may be incorrect.   Please review the URL below and make sure that it is spelled correctly. 

    Requested URL: /MySite/Sitefinity/Admin/Default.aspx

    Version Information: Microsoft .NET Framework Version:2.0.50727.3053; ASP.NET Version:2.0.50727.3053

    For this, I see the sitefinity database table (sf_SecPerms table) and it has the row as follow:

    Application : /
    RoleProvider : Sitefinity
    Role : RoleName
    ItemType : Telerik.Cms.Security.GlobalPermissions
    ObjectID : SecurityRootID (from CmsVariables table)
    Grant : 16
    Deny : 0

    For your kind information, when I logged into sitefinity as admin and I see in Administration->Permissions->Selecting Role->CmsAccess is not checked.  And when I set the check box values (CmsAccess) as true, then I can able to logged into the sitefinity by giving the user credentials as user name and password (user created by stored procedure).  Again I set the CmsAccess as false and I see in database table (sf_SecPerms table), the value has changed from 16 to 0 (Grant field).  And I tried to change the value from 0 to 16 in database table (sf_SecPerms table) manually, but no luck in sitefinity front-end (means I can't logged in by user credentials).

    So please let me know how can I set the CmsAccess to particular role, so that a user can easily logged into sitefinity by giving user credentials without any problem.

    Or please let me know on changing CmsAccess value in sitefinity by logged as Admin, which table (in sitefinity database) is reflecting/changing value, so that I can test by changing the value in database table and see the effects in sitefinity front-end.

    Suggestions are always welcome!

    Varinder Kumar
  2. Radoslav Georgiev
    Radoslav Georgiev avatar
    3370 posts
    01 Feb 2016
    02 Aug 2010
    Link to this post
    Hi Varinder Kumar,

    Thank you for using our services.

    We do not recommend that you work with the Database directly. We recommend using our API for this. You can find an example on how to achieve this here: Setting and Getting Global Permissions.

    Sincerely yours,
    Radoslav Georgiev
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
2 posts, 0 answered