logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
View
Go to last post Go to first unread
Ramneet Chhina  
#1 Posted : Friday, April 8, 2011 10:17:23 AM(UTC)
Rank: Newbie
Ramneet Chhina
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.

skdutta  
#2 Posted : Friday, April 8, 2011 11:07:51 AM(UTC)
Rank: Administration
skdutta
Groups: Registered, Developer, Administrators

Posts: 257
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 :)

SK Dutta,
Architect OfficeClip LLC,
Web-based Business Software,
Ph: +1-770-448-7375,
Web: https://www.officeclip.com

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.