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)?

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

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.

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

Thanks for the additional information.