I am having trouble getting a new feature to work in Dimensions 5.6. I have tried modifying SampleMgtGUI.Config.Xml per the instructions documented in the DDL topic "Controlling Access to Sample Data" to restrict a role from creating a new sample table in a designed sample database. An example of my config.xml file is presented below. Has anyone had any success in getting this to work? It appears that even though I am trying to Restrict the "SampleDatabaseTest" role to only upload to "restrictedTable" in the "Participants" database, the GUI will still let me create new tables and upload to them.
On a related note, I am also having trouble using SQL Server Database alias names set up in the SQL Servicer Client Network Utility (using cliconfg). It appears that if I set up an alian name and then specify the alias name in the server tag, I am unable to see all the databases listed (even if I remove the database and table tages). Has anyone experiened anything similar? Does anyone have a work around (short of writing a custom app)?
Thanks.
--Mark J. Lamias
- Code: Select all
<?xml version="1.0" encoding="UTF-8"?>
<SampleManagementGUI showexistingonly="false">
<Role name="SampleDatabaseTest">
<Server name="MySampleDatabase" cancreatenewdatabase="False">
<Database name="Participants" cancreatenewtable="False">
<Table name="restrictedTable" />
<Field name="*" />
</Database>
</Server>
</Role>
<Role name="DPMAdmins">
<Server name="MySampleDatabase" cancreatenewdatabase="True">
</Server>
</Role>
</SampleManagementGUI>