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.