This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Is it possible to query the current user's permissions using just SuiteQL?

I found <https://timdietrich.me/blog/netsuite-suiteql-access-token-queries/|this resource> which is helpful for finding all user permissions for oauthtokens, but it doesn't tell me who the _current_ user is.

You can use the runtime module to get the current user and then get the current user’s permission

Using the runtime module requires changing the suitescript, correct?  Do you know if it's possible using only suiteql?

what do you mean by changing the suitescript?

```var userObj = runtime.getCurrentUser();
var userPermission = userObj.getPermission({
    name = 'ADMI_ACCOUNTING'
});```
There probably is a way. There are a few tables I saw. It would be a matter of linking them correctly.

PermissionType
rolePermissions
employeeRoles

&gt; what do you mean by changing the suitescript
In the environment I'd like to retrieve this information, I don't have the ability to change the suitescript being executed, but I _do_ have permission to run suiteql queries.

That's why I'd like to be able to run this entirely in suiteql.

I found a workaround here.  I can use the `tokeninfo` <https://docs.oracle.com/en/cloud/saas/netsuite/ns-online-help/chapter_157017286140.html|endpoint> to get the current role, then work backwards to get the permissions.