edit button sql permission

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...

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

Button.Enabled = HttpContext.Current.User.IsInRole("Editors")
 
Do i do this in sql server roles or visual studio application configuration?
Click to expand...

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?
 
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?
 
Back
Top