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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-13-2022 08:48 AM
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-14-2022 08:47 AM
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.