edit button sql permission

[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

 

[Alexey Smirnov]

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.Current.User.IsInRole("Editors")

 

[Guest]

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]

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?

 

[Guest]

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?