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

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

List all users roles, permissions

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :

is there a system stored proc that will allow me to list all the users for a database and their roles permissions?


If not does some one have a script or something I can use...I am relatively new at this and need it for an auditor ASAP!!



View Complete Post

More Related Resource Links

Customized list views and permissions to specific group users

Hi, I have created a custom list with 20 field/columns in wss3.0. I had four user groups(group1, group2,....3.....4) in my site collection with various levels of permissions. I have created four custom views (Group 1 view, Group2 view,...etc)in my list. Each view contains only certain fields out of 20. For example group 1 view contains field 1, 5, 7,10 and 13 of every item in my list.  My requirement is that when a user login, who is a member of group1. he should be able to view only Group1 view fields. He should not able to view other field/columns. I tried creating another field/column called as restricted users and wrote group names in that. In the View edit page I selected " show item when the column 'restricted users' is equl to [Me]. But I did not get it. Kindly help it out any one either programmatically or UI based. Thanks   

How to properly configure permissions so users can view, add, edit, and delete list items, but not w

I am trying to figure out how to properly setup security so that it can be configured at the top-level, and then inherited all the way through. Here is what I would like to do: Each user can view, add, edit, and delete list items - but, users cannot modify or delete web part pages. The only way I know how to do this is set Contribute from the top-down, and then go into each Site Pages library and set Read access. The problem is that I have 100 sites, and I was hoping there was a way I could set security at the top, and inherit downward. Rather than having to go into all 100 Site Pages library and set Read access. Is there a way to do this? Thanks in advance.

Grab a users/roles list?

Just wondering how to implement a user's list into my website ? im using ASP.NET C#. I want to be able to:add/delete usersadd/remove roles

Getting users list reporting to manager from LDAP


Dear All,

I need to get list of users reporting to a particular manager from the Active directory.

In the active directory there is manager property with contains the data in the following way.


Please help me in building the filter condition.

I am using the following

pUserName="Gegore Lid";

strSearch = "(&(objectClass=user)(objectCategory=user)((Manager cn=" + pUserName + "))";

DirectorySearcher dSearcher = new DirectorySearcher(dEntry, strSearch);

            //Account properites to load
            string[] arrPropertiesToLoad = { "displayName", "department", "manager", "sAMAccountName", "EmployeeNumber", "Title" };

          SearchResultCollection sResultColl = dSearcher.FindAll();

 the above code is not returning any result.

Please help me in this.



Getting list of users reporting from specific Manager from Active Directory


Dear All,

I am have requirement like displaying all the user information reporting to specific manager from Active Directory.

Please help me regarding this.



List Users from Active Directory


When i try to List the users from Active directory, i get this exception.

Error while processing.System.Runtime.InteropServices.COMException (0x80072020): An operations error occurred at System.DirectoryServices.DirectoryEntry.Bind(Boolean throwIfFail) at System.DirectoryServices.DirectoryEntry.Bind() at System.DirectoryServices.DirectoryEntry.get_AdsObject() at System.DirectoryServices.DirectorySearcher.FindAll(Boolean findMoreThanOne) at System.DirectoryServices.DirectorySearcher.FindAll()

The code i used is :

DirectoryEntry de = new DirectoryEntry(_path);DirectorySearcher deSearch = new DirectorySearcher();

deSearch.SearchRoot =de;

deSearch.Filter = "(&(objectClass=user) (cn=" + UserName +"))";

SearchResultCollection results = deSearch.FindAll();

 But the DirectoyEntry method is getting validated if i use the overloaded method : DirectoryEntry(_path, domainAndUsername, password);

Please advice me.

Assigning users when creating a list item in a workflow


I'm using a workflow to assign tasks to users.  When I try to assign the task to a group (set in the workflow designer), the workflow gives me an error.  When I change the assign to property to a single user, the workflow works perfectly.  How do I get the workflow to assign the task to the group?  Or if that's not possible, can I get it to assign it to more than one user?


Is there any way to list WebPart's authorised users?


Actually, I set access to some of the WebParts to desired group of SP users. (Web Part edition->Advance->last option on the bottom)

Is there any way to list this access? I'd like to have some kind of list with WebParts and users signed to its.

Access denied to folder in ASP.NET project either though I have granted all users full permissions !



i have made a very simple file upload app, that i want users to be able to upload images to a folder on my server, well localhost for the time being Stick out tongue

here is the simple upload code...

        protected void ButtonRegisterDetails_Click(object sender, EventArgs e) 
            // display properties of the uploaded file 

E-Mail Alerts for users on Task List


Is there any way to send e-mail alerts to a specific user wihtout assigning them the task or having them subscribe to the list.

It's a Task List on WSS 3 on Win2k3 Enterprise'


sql server agent roles and permissions

hi does any one have idea of what kind of roles are needed for creating a SQL server agent job and why those roles are needed?? Please Reply ASAP Because i don't have sysadmin rights.........so that other developers can use the same login for creating the jobs Thanks in advance

Checking SQL Server User Roles and Creating SQL Server Users using VB.NET

Hello gurus!Firstly I want to apologies if this question is out of place here.. if someone can direct me to the correct forumn great and Thanks!I have a VB.NET application which uses its own Backend Database (MSSQL Server). I need to distribute this application to sites where there will be an existing SQL Server.So I will need to Create the Database on this server. The Application includes methods for building the database on startup if not already connected to one.However the users windows logon may not have the correct permission to connect and create a Database on the Server. I have a DB Setup form in my application which asks for the Servname, Username, Password and Database name. I have catered for Windows Authentication and SQL Server Authentication within the form - the user makes the choice.Assuming they enter a Username and Password for SQL Server Athentication then I will be trying to connect using this user and create the database on the given server. The following is my outline logic:-                                                                  Create db Process                                                                             |                                                                             |                                                               Check Credentials                                                                   / 

List View Permissions and Views for Web Parts

My fellow developers and I are going in circles a bit with our new Sharepoint 2010.  This question probably has several different answers.   I have a list of grades and comments that our Team Leaders want to create and save on Sharepoint.  When saved, the user who was graded should be able to see their own grades.  Its a pretty simple requirement and I'm 90% of the way there.   I created a list with the required fields, and two separate views.  The first view filters the list by the user's name so they see on their grades.  The second view shows all grades in a grouped order by the person who assigned the grade.  To make this second view more readable, I added some formatting with Sharepoint Designer 2010.  It looks nice.   Here's where the speed bump occurs.  I create a web parts page for each view.  The page showing only the user grades works as expected.  The other page, however, shows the list in a view that I didn't create.  No matter what view I select from the "Edit Web Part" menu, it always shows this strange view.  If I select the list, it says its current view is "Default".  The second view I created is set as default, but its not the view I see.  If I change the current view from list menu to the second view specifically, it shows up correctly. &n

Map Asp.net website Roles and Users to Sharepoint website roles and users

Hi I have created an asp.net website with SQL Server based form authentication and authorization. Now, we are moving this pure asp.net website to Sharepoint 2010 website. I have developed 5 webparts for my asp.net website to migrate to Sharepoint. All these webparts are avilable for access in the same page. Now I need to implement authentication and authorization for access to these webparts in Sharepoint. I am newbie to sharepoint. Can someone provide me how can I provide authorization and authentication in Sharepoint, which should use the current SQL Server based form authentication and authorization(roles and users of my existing asp.net website) and how can I map roles and users of my existing asp.net website to Sharepoint. Please reply ASAP. Thanks & Regards Mahendra Babu

how to change the permissions list items using the workflow?

How to change the permissions list items using the workflow? Or how to instull SPDActivities on sharepoint 2010?

Item/Document permissions affect Library/List permissions

When I change the permissions on a item/document in a library/list the permissions are also changed on the library/list even though I stopped inheritance.  When I change the permissions on the library/list it also changes permissions on items/documents in that list even if inheritance is removed.

Help with Workflow Task List Permissions

Here's the scenario:  I have a workflow that is assigned (in parallel) to a series of people.  I've limited each person's permissions within the Workflor Task list to strictly edit by creating a custom permissions level.  So now workflow participants are able to Approve the workflow task, but cannot delete the item.  However, now, I wish to limit the tasks a user can approve to only the items that are assigned to them.    I assumed that the (Workflow Task List > List Settings > Advanced Settings >  Item Level Permissions > Edit access: Specify which items users can edit) set to 'Only their own' would do the trick, but that setting doesn't seem to impose any limitation on which task item a user can edit.    Oddly enough, when I set the (Read access:  Specify which items users can read) to 'Only their own' I loose access to every single item in the task list; even the ones that are assigned to me.  What gives?  I thought maybe SharePoint's interpretation of 'their own' possession was linked to who created the item instead of who it's assigned to, but these 2 behaviors don't seem to support that theory at all.    Is this a bug in SharePoint because I'm stumped.   Thanks! -Tracy
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