Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 5 of 5 total |
Create user with only view to tables, triggers, procedures and functions |
Thu, Jan 14 2021 7:27 AM | Permanent Link |
Mike | I need to give someone access to a live database for an audit.
Is there an easy way to create an user which only can view tables, triggers, procedures and functions (readonly)? |
Wed, Jan 20 2021 1:09 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Mike,
<< Is there an easy way to create an user which only can view tables, triggers, procedures and functions (readonly)? >> If you don't need the user to be able to access the Configuration database for system information, then yes, it's fairly easy. Just create a role that only has read-only access to those objects, and then make sure to grant *only* that role to the designated users: https://www.elevatesoft.com/manual?action=viewtopic&id=edb2sql&topic=User_Security If you have any further questions, let me know. Tim Young Elevate Software www.elevatesoft.com |
Thu, Jan 21 2021 11:16 AM | Permanent Link |
Mike | Hi Tim,
Thank you. To view only a stored procedure should such a role have privilege 'Execute' set? A user with this role can still execute the procedure. This is not allowed. |
Fri, Jan 22 2021 12:08 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Mike,
<< To view only a stored procedure should such a role have privilege 'Execute' set? >> In EDB, the Execute privilege determines visibility *and* whether it can be executed. https://www.elevatesoft.com/manual?action=viewtopic&id=edb2sql&topic=User_Security (at the bottom under "Privileges") Tim Young Elevate Software www.elevatesoft.com |
Sat, Jan 23 2021 6:11 AM | Permanent Link |
Mike | Thanks for the additional information.
|
This web page was last updated on Tuesday, May 7, 2024 at 06:25 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |