Hi.I wanna develop an accounting , Payrol System. in my old system, i Create one table for users and all objects in db are in this table. by value of this fields i control the access of users in application.
but in some application , some users,roles defined in Database and users that define from application mapped to this users.
1) how to do this work.
2) hand-rolled security is better than SQL Server Security?
thanks.