May 21, 2010 at 6:23 pm
Newbie to SS, Ignorance can be either corrected or excused
I have a scenario where There are clients named a,b,c,d,e,f who connect to website using a Login/ID n Password.
I have some tools n applications on my website.
Some of which can be accessed by some clients forever and
some of which cant be accessed as of now..
Some of which can be accessed in future
When i say future i mean not after certain time but after clearing some gateways like clearing steps in the access of application.
More clearly:
I have some features(involves apps n data) on my website named f1, f2 and f3
Today 'a' can access 'f1'.. ............... access prohibited to 'f2' and 'f3 '
But since 'a' is done with 'f1' and WE HAVE TO REALIZE THAT(SOME KIND OF TRIGGER SHOULD LET US KNOW THAT IT IS DONE) and now let
'a' access 'f2' .................................access prohibited to 'f3'
so basically access to the features n data depends on the current standing of clients and their stand keeps changing dynamically as they progress.
How do i do that ?
I know my explanation is pretty complicated.IF you felt that your time is wasted just forget it.
[font="Verdana"]
Today is the tomorrow you worried about yesterday:-)[/font]
May 21, 2010 at 10:39 pm
Honestly, this would have very little to do with SQL Server.
Roles and Authorization for web applications are usually managed by the code of the application itself.
You could leverage something like ASP.Net Membership, which uses SQL Server. But, your authorization logic would still exist in the web app.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply