Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
MikeRWolf
Starting Member
1 Post |
 Posted - 2014-06-23 : 21:02:16
|
| Hello everyone, first time poster. I am currently working on designing a database for a bank as a school project for my database class. We have to draw up an entity relationship diagram, Sql tables, database size estimate etc. I am currently working on the security portion of the project and wondering if I could get some opinions and tips. I need to list the groups that have access to my application and use a grid format to show access to specific tables. I am currently doing something like this. Am I going in the right direction here? Is there something I am missing possibly? Best regardsHello everyone, first time poster. I am currently working on designing a database for a bank as a school project for my database class. We have to draw up an entity relationship diagram, Sql tables, database size estimate etc. I am currently working on the security portion of the project and wondering if I could get some opinions and tips. I need to list the groups that have access to my application and use a grid format to show access to specific tables. I am currently doing something like this. Am I going in the right direction here? Is there something I am missing possibly? Best regardsRole Loans Payments Transactions Accounts Customer Emplo Database Admin SUID SUID SUID SUID SUID SUID Branch Manager SUI SUI SUI SUI SUI SUI Internal Auditor S S S S S SLoan Officer SUID SUI SUI S S Tellers S S S S SUCustomers U |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2014-06-25 : 01:41:36
|
| The process of analysing the various roles is good. Assign the least amount of security access required for every role, and then add users to the relevant role.As the db grows and the user base grows security requirments can get complex - therefore maintining role based security will simplify managementJack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
|
|
|
Database Security