AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Accessible synonym2/2/2024 If you want/need to point synonyms to other synonyms, you have to put a real DB object in between (i.e. Synonyms cannot be used as base objects for other synonyms. Also, you can use a synonym to give an object a more convenient name, possibly in your own schema. There is no measurable performance penalty for using synonyms instead of their base objects. Currently, synonyms can be created for tables (this includes virtual tables), views, procedures, table functions, scalar functions and sequences. You can use synonyms to hide the concrete object names from consumers, allowing you to exchange the concrete objects later, without the need of changing their consumers. A synonym belongs to its own schema, which is independent of the schema the DB object belongs to (of course, a synonym and its base object can have the same schema). Whenever you use a synonym, try to mentally replace it by its base object, that’s pretty much the same what the DB is doing. Synonyms are aliases for DB objects, but are no real DB objects by themselves (even though you can find them in view SYS.OBJECTS) . with some Admin-User: create user that PROVides the base object, and two CONSumer usersĬreate user SYN_PROV PASSWORD "Init1234" NO FORCE_FIRST_PASSWORD_CHANGE Ĭreate user SYN_CONS PASSWORD "Init1234" NO FORCE_FIRST_PASSWORD_CHANGE Ĭreate user SYN_CONS2 PASSWORD "Init1234" NO FORCE_FIRST_PASSWORD_CHANGE The easiest way to do this is to open three SQL consoles, one for each user. That could be an end user, that is not allowed to access the replicated ERP Schema directlyįor simplicity reasons we will create three users and work directly with those users and their default schema, which has the same name as the user. When you read something like “–user SYN_PROV:” in the examples, this means, that the coding has to be executed by this user and the current schema is the default schema of the user.
0 Comments
Read More
Leave a Reply. |