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


Post New Web Links

how to implement field-level security

Posted By:      Posted Date: October 21, 2010    Points: 0   Category :SharePoint
 
I need to set up a list in which "A" users can only view and edit a subset of the fields in a custom list, while "B" users can veiw and edit all fields.  It would also be nice if, when an "A" user creates a new list item, one of the fields that is only accessible to "B" users could be set to a pre-determined value.

I'm open to different approaches here (different views of the same list, different lists with some automated way to copy items from the one list to the other, a single view of a single list with some mechanism to enforce the restrictions outlined above, or perhaps some other approach I haven't thought of).  My biggest concern is that the solution be as straightforward and simple to implement as possible.  I'm an experienced VB/C#/SQL developer, but my exposure to SharePoint has been limited to setting up and customizing very simple sites via a web browser.  I have absolutely no experience using SharePoint Designer, or any other SharePoint development tool, and am not sure I will have the time to learn it to complete this project.

Thanks in advance for your suggestions.


View Complete Post


More Related Resource Links

Secure By Design: Your Field Guide To Designing Security Into Networking Protocols

  

If you were to build a new communications protocol from scratch, how would you address security? Here the authors take a look at that question and generate some valuable insights into secure protocols.

Mark Novak and Andrew Roths

MSDN Magazine September 2006


Secure It: WS-Security and Remoting Channel Sinks Give Message-Level Security to Your SOAP Packets

  

As more organizations adopt XML-based Web Services, the need for message-level security has become evident. WS-Security, now supported in the Microsoft .NET Framework, addresses this need. Using the WS-Security framework, developers can implement channel sinks to intercept Remoting messages as they pass through the .NET Remoting infrastructure. The sink can read the message, change it, and pass it along. During this process, the message can be signed for added security. This article explains how to implement a Remoting channel sink that will modify the Remoting message by including a UserName token in the header, then sign the body using the token.

Neeraj Srivastava

MSDN Magazine November 2003


Report Level Security in SSRS using Tsql

  
So i am Brand new in this area i have developed reports before and deployed them but never got an oppurtunity to work on security and who gets to see what.. Purpose of the view is thats what im thinking..   We have a reports database has 100 reports . What we are trying to do is have a faster way to manage report subscriptions. The tables i have is Analysts, SalesRep,SalesRepSubs and dbo.users.Dbo users are our web portal users where they can view reports. I want to create a table in which every report is viewed per security level. We have 6 layers of security layer 1 is lowers to layer 6 being highest. This is the relationship between tables Salesrep(SRID PK) Salesrep_sub (SRID_SUBID PK) Analysts : (AnalystIDPK) Users: The Table has all Users who are Salesrep,Sales Repsub and Analysts)(PKID PK) and we have cols SRID, SRID_SUBID & AnalystID) in this table. use Pricing go Alter View dbo.User_Access   AS select S.SR_name,u.SRID,sr.SRsub_name,u.SRID_SubID,U.Userid,u.username,u.Email, u.SecurityLevel,a.AnalystID from dbo.Users u join tbl_Analyst a on a.AnalystID=u.UserID join tbl_SalesRep s on s.SRID=u.SRID Join tbl_SalesRep_Sub sr on sr.SRID_SubID=u.SRID_SubID My question is what do i do next? Add this view to Report server? or how can i make it functionl?????????FM

Report Level Security in SSRS using Tsql

  
So i am Brand new in this area i have developed reports before and deployed them but never got an oppurtunity to work on security and who gets to see what.. Purpose of the view is thats what im thinking..   We have a reports database has 100 reports . What we are trying to do is have a faster way to manage report subscriptions. The tables i have is Analysts, SalesRep,SalesRepSubs and dbo.users.Dbo users are our web portal users where they can view reports. I want to create a table in which every report is viewed per security level. We have 6 layers of security layer 1 is lowers to layer 6 being highest. This is the relationship between tables Salesrep(SRID PK) Salesrep_sub (SRID_SUBID PK) Analysts : (AnalystIDPK) Users: The Table has all Users who are Salesrep,Sales Repsub and Analysts)(PKID PK) and we have cols SRID, SRID_SUBID & AnalystID) in this table. use Pricing go Alter View dbo.User_Access   AS select S.SR_name,u.SRID,sr.SRsub_name,u.SRID_SubID,U.Userid,u.username,u.Email, u.SecurityLevel,a.AnalystID from dbo.Users u join tbl_Analyst a on a.AnalystID=u.UserID join tbl_SalesRep s on s.SRID=u.SRID Join tbl_SalesRep_Sub sr on sr.SRID_SubID=u.SRID_SubID My question is what do i do next? Add this view to Report server? or how can i make it functionl?????????FM

security top total and current level

  
the locig of data is Country 1 - City1 - Company1 -> Nett Income Country 1 - City1 - Company2 -> Nett Income Country 1 - City1 - Company3 -> Nett Income                                                  Total Income   How can i achive the following logic  - the user (role) Company2 have to see only Total for City 1 (Company1+Company2+Company3), just total and Country 1 - City1 - Company2 -> Nett Income I can use dimension data and check Country 1 - City1 - Company2 but in this case he/she can't see totals for City 1 any ideas ?  

How to Provide Security at User level base in asp.net for certain pages

  
 Hi I have a site We have different Pages under one folder. we have stored these pages information in a database table with pageid. Then we have User access table. there we store userid and pageid , for which pages user has access. Now I need to provide access to that pages only . What to do. Could you please provide answer asap.   Thanks  

Transport level security with netTcpBinding

  
Does service and client need to be part of domain with netTcpBinding endpoint configured to used Transport security mode with Certificate based client credential type and protect level set to EncryptAndSign <bindings> <netTcpBinding> <binding name="CertificateWithTransport" maxBufferPoolSize="100000000" maxBufferSize="100000000" maxReceivedMessageSize="100000000" portSharingEnabled="true"> <readerQuotas maxDepth="100000000" maxStringContentLength="100000000" maxArrayLength="100000000" maxBytesPerRead="100000000" maxNameTableCharCount="100000000" /> <security mode="Transport"> <transport clientCredentialType="Certificate" protectionLevel="EncryptAndSign"/> </security> </binding> </netTcpBinding> </bindings> Thanks      -= JL =-

Field level permissions on WSS 3.0 lists

  
I am using the Help Desk template, and need to lock it down a bit.  I would like to keep users from changing the Priority field on both the NewForm.aspx and EditForm.aspx pages.  I need my technicians to be able to edit the field, but would like it to either be hidden from the user, or have it displayed like the "Assigned To" field where it says " The control is not available because you do not have the correct permissions."   Someone suggested adding JavaScript to the pages in SharePoint Designer, but I do not know how I could wrap those fields in JavaScript so that it checks group membership.   Is what I am looking for too complex for SharePoint, or is there hope?   -Derek Brown Sr. System Engineer Vision One IT Consulting dbrown@v1corp.com

Best way to implement security for measures in SSAS

  

Hi SSAS gurus,

 

I have a requirement where I need to implement security on some measures such that it is visible to a set of users and not accessible to another set of users. Now, I also have SSRS reports defined on top of these measures which are accessible by both the set of users. I want the reports to be displayed such that the measures should be visible to the users with access but invisible or N/A should be displayed when the other set of users access the reports. What would be the best way to go forward for this?


Cheers, Jason 

Page Level Security

  

How do I limit what User/Groups can see a page in SharePoint 2007? Within on particular SITE, I want to be able to say, for example, only Users in the X group can see this page.

I see on the Page Setting the "Audience Targeting" option, but that does not restrict anyone outside that group from clicking "All Site Content" then finding and opening the page from under Pages.

Can someone point me in the right direction?

Thanks in advance.


Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.

Menu - Role security not working on second level of sitemap

  

I have role assignments on both the first and second level of my menus within my sitemap file.  The first level works fine, and I only see items assigned to my role.

But roles assignments seem to have no effect on the second level.  It seems like if you have access to the first level, you have access to everything on the second level.

Is this correct?


From my sitemap (either a SalesRep or an Administrator can see everything underneath):

    <siteMapNode title="Administration" roles="SalesRep,Administrator" description="Admin" >

      <siteMapNode title="CompanyMaintenance" roles="SalesRep" url="~/Admin/CompanyManagement.aspx" />

      <siteMapNode title="Initialize Roles" roles="Administrator" url="~/Admin/Roles.aspx"/>

    </siteMapNode>

From my config:



    <roleManager enabled="true" defaultProvider="SqlRoleProvider">

How to implement Security RTP in RTC Client

  

Hello! I am developing a VoIP softphone in C# using RTC Client API. I need to add Security RTP but I don't know how because I don't know if RTC Client supports SRTP.

 

Has anyone any idea or another way to get it??? Thank you.


Item Level Security Using Column Values

  

 

Has anyone successfully implemented item-level security in a SharePoint list using column values as the decision criteria? I realize this isn't out of the box functionality and would need to be custom coded.

 

For example, let's say that we have one document library that stores all of the HR documents about every employee in the company. One of the columns in the properties of the document stores which Office that employee reports to. There are HR staff that support each Office and should only have access to the files of employees who report to the same office that they do.

 

I know an option would be to create separate library or folder structures for each Office, but I'm curious if anyone has attempted to secure items or documents using properties instead.

 

Thanks.


Select statement with two group level to create addtional field.

  

Here is an example of my question

I have  a column called Department, a column called Employee Name and a column called EmployeeAbsent.

Obviously i can easily use a select satement to get each employee's absent status. However, I would like to generate an additional field called DepartmentAbsent to see if anyone in a particular depart is absent based on the EmployeeAbset field.

how should I write the query?


Row level security in 2008

  
Is there a row level security feature in SQL 2008? I found couple of topics about this but not clear answer. Is there this feature in 2008 or I have to implement row level manualy? Thanks

Field Level Permissions

  

For an example, let's say I have created a custom content type with the text fields: Name, Address, Phone, Manager, Customer.

I want to create 2 permission levels - 1 will allow users to edit Name, Address, Phone, and the other to allow users to edit Manager and Customer. How would I go about doing this? The other fields should be read-only depending on the permission level.

Thanks,
Igor


database level security

  

Hi Team

 

How can we give a security on  a  database 

using DMV and login,user other secuirty options please guide me.

 

Tx

 


subu
Categories: 
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