GRANT IMPORTED PRIVILEGES ON DATABASE - Limiting Objects

Viewed 2868

GRANT IMPORTED PRIVILEGES ON DATABASE TO ROLE - This provides read access on 'all' objects in the database to a role, instead how to limit read access to subset of objects on database instead of all objects in database.

1 Answers

I suggest creating VIEWs with appropriate access privileges on the SHARE objects.

Related