Once a workspace has been created on the Enterprise Analyzer server machine, other users can connect to the workspace from EA clients.
If you use the local MS SQL connection, you need db_owner permissions, because this type of connection creates a database. But if you use the left option, MS SQL via OLE DB, you need a database already created by an administrator. For this database you may have less permissions and the roles can be: db_writer and db_reader.
To grant permissions, run these queries:
USE mydatabase; GRANT ALTER TO myuser; GRANT REFERENCES TO myuser; GO
ALTER permissions are required when upgrading, or using Configuration Manager in the Administration tool. ALTER is also needed by the Batch Refresh Process and Code Search.
When you connect to a workspace, you create a link file with connection information that points to the workspace. Because the connection information is already stored in the file, you don’t have to enter it again when you reopen the workspace connection. Like a workspace file, a link file has a .rwp extension.