In production, we have a special logon we use to view information but not change it. This logon called support has the following permissions:
grant create session to support;
grant alter session to support;
grant select_catalog_role to support;
grant select any table to support;
I am not able...
I changed the default extension for sql scripts to VW just for this issue, and the VCS plug in still saves views with sql extension. It appears the VCS plugin doesn't look at preferences for this.
By default when I export user objects, the extension of the files including views is "vw". However when adding a view to source safe using the VCS plugin the extension of the file in source safe is "sql". Is there a way to check in a view with vw extension using version control over DB objects?