Skip to main content

Bulk assign permission set with Data-Loader

Many times, we come across scenarios where we need to assign all the users in a "Public Group" with a specific "Permission Set". Looks like a genuine & monotonous problem right? Well, yes it is right as you need to add the users one-by-one or by using the great app-exchange product "The Permissioner". What can be irritating is, when there are different users whose usernames are starting with different letters and suddenly the app crashes. Frustrating AF.!!!!!!!!
To put an end to this problem, let me share with you a simple technique that can actually take away all the nightmares of such problems from you.
"Data-Loader" - A very simple, yet very powerful tool that is actually what your savior is. Wanna know more about 'HOW'? Read On!!!
Let us assume, the group whose users you would like to assign a specific permission set to be "My Group" with the ID "00G0O000001fMc0UAE"
The permission set that we want to assign - "My Permission" - ID ="0PS20000000Wf2V"

Step 1: Find out all the users who are present in the Group and export the details in the CSV file. Use the below query:
--> SELECT GroupId,UserOrGroupId FROM GroupMember WHERE GroupId = '00G0O000001fMc0UAE'
Step 2:-->Open Dataloader
Step 3:--> Insert Operation
Step 4:--> Select the object --> "PermissionSetAssignment"
Step 5:--> Create the CSV. --> To create this, open the CSV file that you exported, replace the column with the header "GroupId", Change the values in this column by replacing the ID's of Group with the ID's of the permission set. Here for our example, we need to change "00G0O000001fMc0UAE" to "0PS20000000Wf2V" and hit the save button.
Step 6:--> Upload the new CSV file, do the mapping and run the operation.

Bingo..!!! You have successfully assigned 1 permission set to 1000+ users in merely 5 mins. 

What are your takes on the above technique? Have something better, do share in the comment section below and feel free to let me know your observations or post in any comments that you might have..!!

Enjoy! Happy Salesforce Days!!
Labels:

Comments

Post a Comment

Popular posts from this blog

Custom Metadata Types

Metadata is something that defines the overall organizational structure. And then if you can create your own,custom types as per your requirements, how good that would be? Hell yeah.!! Post summer 15, you can create your own metadata in Salesforce.  AWESOME.!!!! Custom metadata is customizable, deployable, packageable, and upgradeable application metadata. A custom metadata type is defined as a custom object and is stored in the objects folder. Custom metadata types have a suffix of __mdt (instead of __c for custom objects). Custom metadata type field names have a suffix of __c, like other custom fields. Custom metadata type field names must be dot-qualified with the name of the custom metadata type to which they belong. (SOURCE: https://developer.salesforce.com/docs/atlas.en-us.api_meta.meta/api_meta/meta_custommetadatatypes.htm) The records of custom metadata types are metadata This means that, unlike custom objects or custom settings records, the records of custo...
Post a Comment
Read more

Salesforce Reports & Dashboard

Reports  - The very basics of any business needs which gives a great view about ones organizational status. Be it your sales pipeline, your service queue or marketing insights, one look at a report and you have it all. Sounds amazing isn't it? All the hard work you do, all the tough escalations you manage to handle, all the happy customers or all the dissatisfied customers, everything is represented in numbers and is displayed in graphical form using dashboard or reporting snapshot. Salesforce being a Customer Success Platform has one robust reporting engine which helps us build different insights about how an organization is performing.  In Salesforce we have different tools designed specifically according to your needs. Requirements that are must for your business to grow.  Whatever you do, its all numbers and graphs. :)  Essentially there are 4 types of reports available for use: Tabular Report--  A basic table formatted report showing...
Post a Comment
Read more