after the db

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

Guest

hey all,
ok, i have my database locked down as much as i could. certain groups can do
certain things.
now, when i build my web application over this do i have to repeat the
authorization in the code of "certain groups can do certain things"? Or will
the application inherit that from the database?

thanks,
rodchar
 
It's all a matter of the user account in the Connection String to the
database. Whatever Group that user account belongs to is the database user
that connects to the database.

--
HTH,

Kevin Spencer
Microsoft MVP

Help test our new betas,
DSI PrintManager, Miradyne Component Libraries:
http://www.miradyne.net
 
In IIS i'm specifying Integrated Windows authentication. What I'm trying to
do is enable/disable a button on my web page based on the permissions the
user has on a particular database table.

For instance, if the user has been granted CRUD (Insert, Select, Update, and
Delete) rights in the database then the button should be enabled.

Open to better ideas of doing things as well.

thanks,
rodchar
 
An ASP.Net application runs as a single identity, not as multiple logged-in
users. So, you would have to create a custom Connection on a per-user basis,
rather than using Windows Authentication. What you probably want to do is
implement ASP.Net Membership, which can be tied to Active Directory. See
http://msdn2.microsoft.com/en-us/library/tw292whz.aspx

--
HTH,

Kevin Spencer
Microsoft MVP

Help test our new betas,
DSI PrintManager, Miradyne Component Libraries:
http://www.miradyne.net
 
Thank you Kevin for your generous help.
Rod.

Kevin Spencer said:
An ASP.Net application runs as a single identity, not as multiple logged-in
users. So, you would have to create a custom Connection on a per-user basis,
rather than using Windows Authentication. What you probably want to do is
implement ASP.Net Membership, which can be tied to Active Directory. See
http://msdn2.microsoft.com/en-us/library/tw292whz.aspx

--
HTH,

Kevin Spencer
Microsoft MVP

Help test our new betas,
DSI PrintManager, Miradyne Component Libraries:
http://www.miradyne.net
Click to expand...
 
Back
Top