Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Hide for certain users
- Thread starter mgreich
- Start date
Use of ROLES is normally the most dynamic and easiest configurable. Typical HIDE WHEN conditions like @IsNotMember(@UserRoles; "[Admin]") will hide a field/section/table for all but those who has the role [Admin] assigned...
Some weaknesses AND strengths with the use of roles:
- It should / must be a server based database (Is not working as expected on local databases)
- Enable "Enforce a consistant Access Controll List across all replicas" to make ROLES work properly
- OPTIONAL, but still recommended: Assign a ADMIN server to the DB
- The access must be coded in to the forms that need to hide/when
- ROLES also work on web
Other alternatives is to use access levels, but this is far less dynamic in it's setup...
Brgds,
TrooDOS
Some weaknesses AND strengths with the use of roles:
- It should / must be a server based database (Is not working as expected on local databases)
- Enable "Enforce a consistant Access Controll List across all replicas" to make ROLES work properly
- OPTIONAL, but still recommended: Assign a ADMIN server to the DB
- The access must be coded in to the forms that need to hide/when
- ROLES also work on web
Other alternatives is to use access levels, but this is far less dynamic in it's setup...
Brgds,
TrooDOS
- Status
Similar threads
- Locked
- Question
- Locked
- Question