If the
SAS add-in
attempts to write data to a table on the SAS Metadata Server, and
the structure of the updated table is different, the metadata is not
updated. For this reason, it is advisable to regulate Write access
to registered tables from Excel, Word, and PowerPoint. Read access,
for the purposes of querying SAS OLAP cubes using Excel, requires
no special consideration.
Access to registered
libraries is determined in part by the library access method. By default,
all libraries that are registered on the SAS Metadata Server are Read-only.
SAS Add-In for Microsoft Office
users cannot create, add, or delete tables. The default library access
method can be changed, as described in
Review Library Access in SAS Enterprise Guide.
CAUTION:
To maintain
referential integrity on the SAS Metadata Server, it is advisable
to inform the SAS Add-In
for Microsoft Office users about their permissions to access registered
libraries.