|
-
Maybe some text missed in the answer of Jovery
It should be:
You can then reference the table as schema.table_name.
But keep the next points in mind:
It is a good habit that only procedures etc. in the same schema as the table can modify the table, so grants to other schema_owners can be limited to select on the table and execute on the procedures.
When you like to modify a table out of another schema,
you have to grant INSERT/UPDATE to another schema_owner.
That may cause a leak in security.
Regards
Ben de Boer
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|