The following example first creates a synonym for the base object, Product in the AdventureWorks2012 database, and then queries the synonym. You do not need permission on the base object to successfully compile the CREATE SYNONYM statement, because all permission checking on the base object is deferred until run time. Synonyms can be created, dropped and referenced in dynamic SQL.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |