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 |
|
hdv212
Posting Yak Master
140 Posts |
 Posted - 2009-11-11 : 14:27:23
|
Hifor implementing custom security in my applications i have some tables which demonstrate below :Users : to hold users (like 'John', 'Oliver', ...)Roles : to hold roles (like 'Admin', 'Contributer', ...)UsersRoles : to hold many-to-many relationShip between Roles & UsersAccessLevels : to hold accessiblity levels (like 'Insert', 'Update', 'Select', ...)Objects : to hold application/database objects (like tableName, formName, fieldName)Permissons : to hold which role can have which accessLevels on which objects (like 'AdminRoleID', 'CategoriesTableID', 'InsertAccessLevelID', True)i want to display all options about give permissons settings on each object to the end-user as follow :RoleName------------ObjectName | AccessLevel1 | AccessLevel2 | AccessLevel..N HasAccess HasAccess HasAccessImage : i want a resultSet someThing like above table (or image), if u look at the example of Permissons table, we have these fields :RoleID,ObjectID,AccessLevelID,HasAccessi want a result Set something like cross-tab reports (i'm not sure), but i don't how to accomplish this.how to make this result set or have u better idea ?any help would be great appreciated.regards |
|
|
hdv212
Posting Yak Master
140 Posts |
Posted - 2009-11-12 : 03:10:56
|
| Anybody ? |
 |
|
|
|
|
|
|
|
Custom security implementation : query problem