Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 1 of 1 total

Creating a view only role

Mon, Jan 24 2022 10:00 AM

Permanent Link

Roy Lambert

NLH Associates

Team Elevate

I'm trying to create a role that can view the various tables and queries in a database but not alter them.

Create a role LookOnly
Created a user Looker

ran the following SQL

GRANT SELECT On DATABASE Books TO "LookOnly"
GRANT LookOnly TO Looker
REVOKE Public FROM Looker

Try and log in

---------------------------
ElevateDB Manager
---------------------------
ElevateDB Error #401 The database Configuration does not exist.
---------------------------
OK
---------------------------

Is what I want possible, if so how?

Roy Lambert