.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Resource Governor, IS_MEMBER and custom role

Posted By:      Posted Date: October 18, 2010    Points: 0   Category :Sql Server
I'm doing some testing with resource governor and the is_member function.  I can get it to pick up a user assigned to a standard database role, such as db_owner, but not a custom role I created in a database.  Is there anyway to get it to work with a custom role?

View Complete Post

More Related Resource Links

Smart Cleanup: Achieve More Reliable Resource Management with Our Custom C++ Classes


Managing resources in C++ is not easy. When you're unsuccessful, your app can leak all kinds of resources including file system handles, database connections, and, of course, memory. Even in garbage-collected languages like Managed C++, resource management is difficult because garbage collection only deals with memory management, not the other resources that cause performance problems.In this article, the author describes the SmartAny template library he created, which uses a policy-based approach to dynamic resource management. Readers will learn how to use the SmartAny classes and policies to ensure the proper cleanup of their resources, be they files, OS handles, or native and unmanaged objects.

Eric Niebler

MSDN Magazine June 2003

Custom Role Provider Not Authenticating Users

I have created a custom role provider that is hard coded to say everyone is in a certain group (code below).  I have edited the webconfig of Central Admin, my Web Front End, and the Claims Service.  I can sucessuflly log in using the asp.net membership provider and configured access to the site by adding the "custom" role to the Owner Group.  With all of the above items setup I can launch visual studio and attach the to IIS process and verify that my custom role provider is being called.  Even with all this setup I cannot get another forms based user to be able to access the site.  The other user is getting a sharepoint access denied issues. Any Ideas?   public class IdBasedRoleProvider : RoleProvider { public const string AllAuthenticatedUsersRoleName = "custom"; public override string ApplicationName { get; set; } public override string[] GetRolesForUser(string username) { return new[] { AllAuthenticatedUsersRoleName }; } public override bool RoleExists(string roleName) { if (roleName == AllAuthenticatedUsersRoleName) return true; else return false; } #region Methods Not Implemented public override string[] GetAllRoles() { throw new NotImplementedException(); } public override bool IsUserInRole(string username, string roleName) { throw new NotImplementedException(); } public override void Ad

Sharepoint 2007 Custom Role Provider

I have been trying to configure Sharepoint 2007 to use a custom role provider (using Forms based authentication) that we have developed.  I have been following the tutorial at http://www.andrewconnell.com/blog/articles/HowToConfigPublishingSiteWithDualAuthProvidersAndAnonAccess.aspx, so my configuration files look similar (only database connection string changes).   I have the Membership role provider working (able to add users to my site collection) but am not able to figure out what i have done wrong in setting up the role provider.   To verify that our code works, I setup an empty website project and called the asp.net configuation tool (as described in the above reference article) and am able to view/create/remove/etc... roles as expected, so I think the role provider is working correctly.   What is the recommended way to debug my problem?   Thanks Greg.

user role on sharepoint custom list

hi, can i set up a user role for a custom list form in sharepoint services 3 i want to use the "submit new absence" form. but i need to modify the form in a way that when a user open the form it fills the user his name or login name in the fields. and that the approver or "assigned to field" also is filled with the approvers name. i think i need to use a query for that, but how can i apply it to the fields of the absence list form

custom role manager, type error in Web.config

Hello everybody.I am developping a role provider for AD.I have copy in the root directory of my project in VS2010 the file MyAdamRoleProvider.vb which is an example of a book.I have declared in my web.config the role provider like this: <connectionStrings> <add name="ADService" connectionString="LDAP://webcubedev/OU=webcube,DC=wcdev,DC=local"/> <add name="ADServiceRole" connectionString="LDAP://webcubedev/OU=webcube,DC=wcdev,DC=local"/> </connectionStrings> <system.web> <roleManager enabled="true" defaultProvider="ActiveDirRP"> <providers> <add name="AspNetActiveDirectoryMembershipProvider" type="MyAdamRoleProvider" connectionStringName="ADService" connectionStringRoleName="ADServiceRole" /> </providers> </roleManager> When I debug, the error is "Impossible de charger le type 'MyAdamRoleProvider'"In english : "can't load 'MyAdamRoleProvider' type"I don't see what is wrong, can you help me?

need help with sharepoint (wss 3.0) with Windows authentication and Custom Role provider

I'm trying to setup sharepoint(wss 3.0) to use my custom role provider with Windows authentication. I've modified the web.config to enable role manager and I am able to select my custom roles when assigning permissions but it doesn't seem like sharepoint is check the permission again my custom roles. If I enable Forms authentication and use my custom membership provider it all works as expected but I do not want to use FBA because of the issues with Client Integration. Essentially I want all the features that comes with the default windows authentications but just have permission be control from my custom role provider. Can anyone offer any solution or suggestions?

Resource governor not working as expected.


Greetings. I'm trying to have Resource Governor (RG) not allow any queries run that use >= 1 second of CPU time, and it's simply not working.

I have no doubt that I am doing something incorreclty, but not sure what it is.

 I configure RG with the following:

create FUNCTION dbo.rgclassifier_v1() RETURNS sysname 
  DECLARE @grp_name sysname
   IF (SUSER_NAME() = 'sa')
     SET @grp_name = 'GroupAdmin'
   IF (SUSER_NAME() = 'testAdhoc')
     SET @grp_name = 'GroupAdhoc'
   IF (SUSER_NAME() = 'testReports')
     SET @grp_name = 'GroupReports'
  RETURN @grp_name

/****** Object: ResourcePool [poolAdhoc]  Script Date: 09/28/2010 13:26:11 ******/
CREATE RESOURCE POOL [poolAdhoc] WITH(min_cpu_percent=0, 


/****** Object: WorkloadGroup [GroupAdhoc]  Script Date: 09/28/2010 13:25:30 ******/
CREATE WORKLOAD GROUP [GroupAdhoc] WITH(group_max_requests=0, 
		max_dop=0) USING [poolAdhoc]



 After doing this, I fire

Custom Role Provider - Roles.GetRolesForUser(userName) raises exception


Hi All,

We have configured Claims based authentication in our application and We have extented the RoleProvider. When we call the Roles.GetAllRoles() method it returns all the roles available in the aspnet_Roles table. When we call Roles.GetRoleForUser(userName) it raises the following exception.

Exception of type 'System.ArgumentException' was thrown.
Parameter name: encodedValue

   at Microsoft.SharePoint.Administration.Claims.SPClaimEncodingManager.DecodeClaimFromFormsSuffix(String encodedValue)
   at Microsoft.SharePoint.Administration.Claims.SPClaimsAuthRoleProvider.GetRolesForUserBestEffort(String username)
   at Microsoft.SharePoint.Administration.Claims.SPClaimsAuthRoleProvider.GetRolesForUser(String username)
   at System.Web.Security.Roles.GetRolesForUser(String username)
   at Dsp.SP.ContentManager.GenericPublishedContent.BindGridPublicGroup(String selectedNode)

When we debug our Custom Role Provider project the breakpoint hits the GetAllRoles() method and it does not hit the GetRolesForUser() method. So we are not sure whether the overridden method is called or not?

Using custom Membership/Role providers for WCF?


I'm currently trying to get the hang of WCF services and build a few test services that do a few dummy things(like a game's highscore service, where you can submit a high score to, get the list of top 10 users in it, get your position in the list and create a new account).

This is all still very basic stuff, since WCF is overwhelming me. What I want to do is write my own custom little username/password store because the default asp.net membership provider is way to complex for me. However, since I intend to write services that do make use of roles when calling it, I decided to add an extra little layer to it, and add in user roles as well. When a user is an admin, it can retrieve the high score list and delete items from it. So, this would result having only 2 roles(submitter / admin).

However, I am completely lost on how to implement it. I've used the Membership stuff before in asp.net, but never wrote my custom version of it, and I'm not even sure if I need to use that. Can anyone shed some light on the situation here?


Custom Profile Provider and Role - Mysql


May I ask if how can I create a custom mysql profile provider with the following properties?

                <add name="ProjectID" type="Int" defaultValue="0"/>
                <add name="TeamID" type="Int" defaultValue="0"/>
                <add name="EmployeeID" type="String" serializeAs="String"/>
                <add name="LastName" type="String" serializeAs="String"/>
                <add name="FirstName" type="String" serializeAs="String"/>
                <add name="MiddleName" type="String" serializeAs="String"/>
                <add name="NickName" type="String" serializeAs="String"/>

Using SQL scripts from a enbedded resource in a custom action


I setup a Custom action that connects and creates a database on the sever. I wanted to use SQL scripts to do this with. The problem is that I added the scripts to a folder off the installer1 project and and it keeps trying to find the sql scripts in the c:\windows\system32 folder.. Then I tried to add them as a Embedded resource and well it keeps erroring out saying 'Error 1001: illegal characters in path'

Any one have any ideas on how to get this to work right, Some of my code it below. from the custom action

string SQLConn = "Data Source=(local)\\SQLEXPRESS;Initial Catelog=master;Intergraded Security=SSPI";
      FileInfo file = new FileInfo(Resource.CreateDataBase);
      //FileInfo file = new FileInfo(@"SQLScripts\CreateDataBase.sql");
      string script = file.OpenText().ReadToEnd();

      SqlConnection conn = new SqlConnection(SQLConn);
        Server server = new Server(new ServerConnection(conn));

My custom role provider doesn`t work


Hi guys.

Have a little problem. I`ve developed my custom role provider to have my implementation of it logic. But during the process i have a problem with this.

I implemented class CustomRoleProvider:

namespace CSSA
    public class CustomRoleProvider : RoleProvider
        public override string ApplicationName
            get { return "xxx"; }
            set { }

        /// <summary>
        /// Add roles to users.
        /// </summary>
        /// <param name="usernames">list of member which need to accept roles</param>
        /// <param name="roleNames">The list of role, which will be apply to user List</param>
        public override void AddUsersToRoles(string[] usernames, string[] roleNames)
            throw new NotImplementedException();

        public override void CreateRole(string roleName)


        public override bool DeleteRole(string roleName, bool throwOnPopulatedRole)
            return true;

        public override string[] FindUsersInRole(string roleName, string usernameToMatch)
            throw new NotImplementedException();

        public override string[] GetAllRoles()

Custom role provider and RunWithElevatedPrivileges(recursive loop)


I've implemented custom role provider. i get users from sharepoint list. But i have problem. if user is loged and if i try call method with RunWithElevatedPrivileges, then RunWithElevatedPrivileges cause call of GetRolesForUser. but in GetRolesForUser i use RunWithElevatedPrivileges and this cause new call of GetRolesForUser.... Any one know how can i avoid this recursion? and why RunWithElevatedPrivileges calls GetRolesForUser? i use custom role provider for asp.net site not sharepoint site. Thx

Custom access denied page for role based security


I have implemented role based security in my asp.net 2.0 vb.net application using windows authentication and the windowstokenroleprovider and limiting access to certain pages using the location tag to specific active directory groups.

The issue is that when a user tries to access a page they are not authorized to view it brings up a login prompt and when it does not pass it takes them to the default page that tells them they are not authorized to view the page. I am wondering if there is a way to throw up a custom page that tells them they are not athorized to view the page that I can incorporate into the site itself with the header and so forth? It would be great if this page could come up in lieu of the sign in box popping up as well.


Custom Role Provider Issue In Sharepoint 2010



I have? migrated my existing wsp solution that contains working custom FBA membership and role providers to Sharepoint 2010. As stated in several migration or custom membership provider articles that I fround in Net for Sharepoint 2010, I followed the steps below:

  • Created my FBA login page under _layouts, I inherited it from FormsSignInPage.
  • Set authentication of the web application to Claims
  • Enabled forms based authentication for the application and set my custom provider names.
  • Added provider names to not only my application's web.config but also to central application web.config and securitytoken web service's web.config (which is located in [14 hive]\WebServices\Securitytoken).

The current issue I am having is as follows:

  • When user types in username and password and presses the login button in the FBA login page, yellow "screen of death" :) is displayed indicating: "The server was unable to process the request due to an internal error.  For more information about the error, either turn on IncludeExceptionDetailInFaults (either from ServiceBehaviorAttribute or from the <serviceDebug> configuration behavior) on the server in order to send the exception information back to the client, or turn on tracing as per the Microsoft .NET Framework 3.0 SDK documentati

Assigning Custom Permission Role to a List Column in MOSS 2007

I have created three custom roles: Role1, Role2, Role3.  I have a user list with permissions column.  This permissions column has three choices in a dropdown list.  I want to associate each value in the dropdown list to a custom role (Role1 or Role2 or Role3).  This way, when I create a new user, I would just have to pick a value in the permissions column.  Oh Yes, I am using MOSS 2007.

Custom Controls in C# .NET

Embedding user controls in a Windows form is just like adding a simple button or text box that are already provided with .NET. These basic controls were written essentially like you code your own controls. Typically the controls you design are to be used in multiple forms or to modularize your code. These reasons help reduce the amount of code you have to type as well as make it easier for you to change your implementation. There should almost never be any reason to duplicate code because it leaves a lot of room for bugs. So, implementing functionality specific to your control in the control's source code is a good idea. This reduces code duplication as well as modularize your code, which is a good programming guideline.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend