OfficeClip Forums
»
General Discussion
»
Developer Resources
»
Custom Coding
»
Adding a new user to a specific role while creating him.
Rank: Newbie Groups: Registered
Posts: 3 Location: Mc Lean, VA
|
When a new user is created, he is added by default to the 'All Users' role which has authorization to view every application. So, one has to manually assign a new user to a specific role with lower privileges. It would be easier if we could specify a specific role for the user while creating him.
|
|
|
|
Rank: Administration Groups: Registered, Developer, Administrators Posts: 254 Location: Atlanta, GA
|
In order to do this effectively, what you need to do is to create a new role that you want user to be a member of. You can create this role using the OfficeClip Setup. Now go to the database and list the content of the roles table. Note the value of the role_id (which is a unique key). Now go to the stored procedure InsInviteMemberSP (in file Sql\Queries\invitemember.sql) and at the bottom of the stored procedure add the following code: Code: insert into userroles (user_id, role_id) values (@userId, <roleId>) -- where <roleId> is the value of the role_id that you found above
Please note that this is a patch way of doing it. If the role is deleted in the future, you may get error when running the stored procedure. A better way of doing is to create a feature within OfficeClip to do this. That I guess is a topic of different discussion :) |
|
|
|
|
OfficeClip Forums
»
General Discussion
»
Developer Resources
»
Custom Coding
»
Adding a new user to a specific role while creating him.
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
Important Information:
The OfficeClip Forums uses cookies. By continuing to browse this site, you are agreeing to our use of cookies.
More Details
Close