grant privilege to user
Currently I have problem with our database has objects in one schema is automatically created daily.
and There is user request to create user for select object for that.
We do not want to grant SELECT ANY TABLE privilege to that user, because it seems not secure then will have
privilege to select and see other object of other schema.
Thus, what should the privilege I can grant to that use to see only object of one schema which it auto create daily like this.
Thanks and Regards,
Vorleak