User Object access in Ajax Toolkit

Question

One of my standard layout button executes JavaScript as: (Only relevant lines posted)

var query = "Select id,Name from User where name ='Integration User' Limit 1"; 
var records = sforce.connection.query(query); 
var records1 = records.getArray('records');  
acc.OwnerId= records1[0].Id;

This code fails for a user belonging to some custom profile. It gives error saying "can not specify id of undefined".

But it works fine for System administrator. Clearly problem is about querying User object and access on user records.

What permission should i consider for custom profile user to give him ability to execute this SOQL.

I would not like to hard code Integration user id in JavaScript code.

Answer 1

Here are some options:

1. Give that profile a permission to View All Users (that's a system permission, not given on the object)

2. Change the Sharing Settings of User to Public Read-only.

3. Call an webservice apex method from a button, just make sure class is without sharing

4. Save the Integration User id on a Hierarchy Custom Setting. That way you can reference it in the button and it easy to change on the future.