How to allow my application to delete records from sys_user_grmember.

[Christopher Lun]

By default my App cannot delete records from sys_user_grmember. I am new to SNOW app development. I am wondering if there is a way to give access to my app to delete, so that I can run some scripted APIs and removes users from groups. I am running my API request from a user admin. Also, I created an app_admin_role in the app, but I am not sure how to give it the right permissions.

[Aman Kumar S]

You can also check "Can delete" field to be able to delete record from the table

[Christopher Lun]

I can check the "Can Delete" in the global, but the intended purpose is that people install the app and be able to used the scripted APIs without them having to tinker with their own instances. Thanks

[Aman Kumar S]

Can Delete works for those who are trying to delete record from scoped application.

If you are looking for scripted rest api access, you need to check delete ACL and check for any role and you will need to provide the same role to the integration user to be able to manage the deletions

[Aman Kumar S]

@Christopher Luna,

I have shared the details above very clearly and categorically, you can refer to the same and mark correct if it answers your query