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 |
|
anujpratap84
Starting Member
45 Posts |
 Posted - 2010-12-02 : 05:00:14
|
| Hi All,i am working on a windows application.For that application i need DB structure to give permission to the each user to insert update delete in each module in application.Anuj Pratap Singh |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-12-02 : 05:18:55
|
| Can you create roles then add the users to the role depending on what they need?Otherwise if you want to control it from the aplication have a table with the user id, module, permissions.For this it really depends on the system - what you want to give permissions on, how you want to control it, what sort of hierarchy is needed...==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
anujpratap84
Starting Member
45 Posts |
Posted - 2010-12-02 : 07:42:13
|
quote:
Originally posted by nigelrivett
Can you create roles then add the users to the role depending on what they need?Otherwise if you want to control it from the aplication have a table with the user id, module, permissions.For this it really depends on the system - what you want to give permissions on, how you want to control it, what sort of hierarchy is needed...==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy.
If user have super admin role than it will see all module and perform all DML operation.but admin can see all module but only insert update not delete data.and rest user have other permission as we'll set through application.So i need DB structure to do this.Anuj Pratap Singh |
|
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2010-12-06 : 06:03:25
|
| create the tables as in the order.i have used it in my application.and give proper relationships between them. 1.USERS 2.ROLES 3.MODULES 4.ROLE_MODULES 5.PAGES 6.MODULE_PAGES 7.FUNCTIONALITY 8.PAGE_FUNCTIONALITIES 9.PRIVILEGES .if u have any doubts you can ask... |
|
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2010-12-06 : 06:07:06
|
| sorry i missed the order.first create 'roles' and then follow up |
|
|
|
|
|
|
Need table structure for module permissions to use