KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I have tables in Schema A. I created views in Schema B using the tables in schema A. I want to grant permissions to a user to select the data from view in Schema B. For this to work i know we have to enable the grant option on tables in Schema A to user B. But I want to do it in a single script (This script has to be in schema B). Is there a way to do this using the user name/password of schema A.
Tags (comma-separated)
Save Edits
Cancel