Hand-Rolled Security Vs using SQL Server Security

SQLServerCentral is supported by Red Gate Software Ltd.

Home Tags Articles Editorials Forums Scripts Videos Blogs QotD Books Ask SSC SQL Jobs Training Authors About us Contact us Newsletters Advertise Write for us

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Security » Hand-Rolled Security Vs using SQL Server...

Hand-Rolled Security Vs using SQL Server Security

Rate Topic

Display Mode

Topic Options

Author

Message

Hamid-Sadeghian

Posted Sunday, November 15, 2009 10:04 PM

Forum Newbie

Group: General Forum Members
Last Login: Saturday, February 20, 2010 6:09 AM
Points: 9, Visits: 21

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.

Post #819185

Jack Corbett

Posted Monday, November 16, 2009 6:57 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 8:57 PM
Points: 8,185, Visits: 7,967

Duplicate question. Please answer here

Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2

Post #819353

« Prev Topic | Next Topic »

Permissions