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 |
|
Seequiller
Starting Member
3 Posts |
 Posted - 2014-01-30 : 14:51:21
|
| To simply:Table names: User, UserRole, RoleValues.Each table has tablename.CreatedBy, tablename.Created, tablename.UpdatedBy, tablename.UpdatedStored procs: UserGetUserByDomainUserName, UserGetByRole, UserRoleGetByUserusername (smithj) authenticate via AD to log into app.Need help creating a join statement to get all permissions for a user, merge all roles together to get a list, but I do not need the actual role values (Administrator, Employee, Assistant). For example, user, smithj, is the "CreatedBy", he can create, edit, everything he creates, but he cannot edit other user's records. Vice versa. Other users cannot edit the "CreatedBy" user's record, but he can only add a report, save. No other changes should be performed. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2014-01-31 : 08:28:00
|
| so what should be your expected output?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
|
|
|
|
|
Create a join for User tables