Welcome to Community Week 2025! Join us to learn, connect, and be recognized as we celebrate the spirit of Community and the power of AI. Get the details  

Permissions for user to create/edit View and to relabel columns on a single table.

User175049
Mega Guru

I have two questions. 

We have a user who is requesting to have the ability to create/edit views on a single table. 

Also, the same user, would like to have rights to edit columns on a single table. 

Are either of these possible to address? 

We want to avoid granting the admin role to this user.  

I'm not finding a solution with using ACLs, but maybe I am missing something. 

 

Thank you.

Melinda

 

 

 

 

5 REPLIES 5

I removed the roles. This is now completely reliant on ACL. The ACLs (write and create) are on the sys_dictionary table with the following script:

 

if (!gs.getUserID("USERID") && gs.tableExists(u_service_oriented_servers));
{answer = true;
}

 

The above is still not granting the access to the u_service_oriented_servers table to edit the columns and View.  This script must be missing something, or I need to add it to a different table.