473,769 Members | 4,985 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

edit button sql permission

hey all,
i have an edit button on my web page. what is the quickest or best way to
link the Enabled property of the button on the aspx page to the User's Table
Permissions if it has been granted update permissions?

thanks,
rodchar
Apr 19 '07 #1
4 1382
On Apr 19, 8:52 pm, rodchar <rodc...@discus sions.microsoft .comwrote:
hey all,
i have an edit button on my web page. what is the quickest or best way to
link the Enabled property of the button on the aspx page to the User's Table
Permissions if it has been granted update permissions?

thanks,
rodchar
Use a role-based authentication. Assign you user to a role (e.g.
"Editors")

Button.Enabled = HttpContext.Cur rent.User.IsInR ole("Editors")

Apr 19 '07 #2
Use a role-based authentication. Assign you user to a role (e.g.
"Editors")
Do i do this in sql server roles or visual studio application configuration?

"Alexey Smirnov" wrote:
On Apr 19, 8:52 pm, rodchar <rodc...@discus sions.microsoft .comwrote:
hey all,
i have an edit button on my web page. what is the quickest or best way to
link the Enabled property of the button on the aspx page to the User's Table
Permissions if it has been granted update permissions?

thanks,
rodchar

Use a role-based authentication. Assign you user to a role (e.g.
"Editors")

Button.Enabled = HttpContext.Cur rent.User.IsInR ole("Editors")

Apr 19 '07 #3
On Apr 19, 10:28 pm, rodchar <rodc...@discus sions.microsoft .com>
wrote:
Use a role-based authentication. Assign you user to a role (e.g.
"Editors")

Do i do this in sql server roles or visual studio application configuration?
Maybe I misunderstood the meaning of your question. Do you need to
know if current SQL-user has an access access to a particular SQL-
table?

Apr 19 '07 #4
i'm sorry for the confusion i'm just trying to understand the best practice
in securing my asp.net solution and sql server 2005 database while they work
together to produce a web application.

here is just random questions i have:
you know application role in sql server 2005, does that in anyway work in
conjuction with an asp.net web application?

"Alexey Smirnov" wrote:
On Apr 19, 10:28 pm, rodchar <rodc...@discus sions.microsoft .com>
wrote:
Use a role-based authentication. Assign you user to a role (e.g.
"Editors")
Do i do this in sql server roles or visual studio application configuration?

Maybe I misunderstood the meaning of your question. Do you need to
know if current SQL-user has an access access to a particular SQL-
table?

Apr 20 '07 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
3115
by: Alex | last post by:
Interested in more .NET stuff visit www.dedicatedsolutions.co.uk The DataList is not as powerful as the DataGrid. It requires more work from you since it has no default data presentation format. However, the DataGrid begins to get very cumbersome as the number of columns of data you present increases. Anything more than half a dozen columns or so and you probably induce horizontal scrolling - a real no-no for me. If you put such a...
4
4413
by: DC | last post by:
Newbie's question about .NET datagrid If I use: <asp:EditCommandColumn></asp:EditCommandColumn> When I edit a row, it will automatically show Update and Cancel Link. But when I use: <asp:Button id="btnEdit" runat="server" Text="Edit" CommandName="Edit" CssClass="clickable"Width="50px" /> When I edit a row, the Update/Cancel links don't show up.
4
3719
by: Glenn M | last post by:
I have a shared XML file on a server . i also have one xslt file that performs a simple transform on in to view the data. now i want to have another page that lets users modify the shared xml file via some editable controls such as text boxes , option boxes etc. how can i implment this , should i use another xslt file with <INPUT> controls . if so how can i save the result back using the asp.net
1
1630
by: Randall Parker | last post by:
Currently in an asp:DataGrid I have a column for bringing up an edit form on a particular row and that is done by a hyperlink as follows: <asp:TemplateColumn HeaderText="Edit Record"> <ItemTemplate> <asp:HyperLink id="hyperlink1" NavigateUrl='<%# "EquipmentEdit.aspx?serial=" + DataBinder.Eval(Container, "DataItem.owner_serial_num") %>' Text='Edit' runat="server"/>
0
839
by: Rob | last post by:
Strange problem. I have a number of datagrids in my application. I have some custom security on my forms and set my datagrid ReadOnly property to true when the user does not have enough permission. When they go to a row on the datagrid and hit the delete button, the row is not deleted but it puts that datagrid row into edit mode that causes other issues. (It actually puts the edit symbol on the row header.) It appears to be a bug...
0
1307
by: lj | last post by:
How do I get an asp.net datagrid to set certain records as tedittemplate based on a certain condition. It is for a simple workflow. The user will have permission to see a list of records. He will be able to select all records he has permission to approve and that have not already been approved and click on a button to approve them. These records I want to display in edittemplate mode with a checkbox. The others I just want to display...
2
2548
by: ruthie | last post by:
Hi, I have a gridview with edit option. If the user chooses to edit the row and then press the Cancel button - I would like the focus to return to the chosen row. Someone has any idea how to implement it? Thanks. Regards,
8
1983
by: =?Utf-8?B?bWlrZWc=?= | last post by:
Hi, I am building a small Help Desk application for my company and need to be able to edit "open" help desk issues. I use a simple datagrid to display each issue (6 per page) , with an Edit button. There are a lot of fields across, and my Network Admins would like a way of editing/updating each issue seperately in a a vertical form. I need a way of clicking on the edit button ,bringing up a form with the record, editng the fields, and...
1
1315
by: =?Utf-8?B?Ym9iYnk=?= | last post by:
Hi, I have GridView. I set AutoGenerateEditButton="True" . When I click this button it puts some fields in edit mode. But I want to add button field in grid View and When I click on that Edit Button It just make other columns in Edit Mode. Because i don't want After clicking the Edit button to be change to Update or Cancel.
0
9589
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9423
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
1
9994
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9863
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8870
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7408
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6673
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
1
3958
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3561
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.