table in scoped application can't reference global table cable

[theiser]

I had built a new  table in a scoped applicationand and  tried to set up a new reference field  that would reference the user table. I could not  find the table. After playing around, if I make the user table extensible then it will show up in the new scoped application table reference. This doesn't  seem logical  but is it?  

[rob_pastore · Accepted solution]

You don't need to extend the user table, try this.

Under System Applications, go to Application Cross Scope Access.

You should be able to create a record like this one, it should allow the user table to be available in your scope.

[dave_knight]

I just reproduced the original issue. Adding the cross-scope read privilege as prescribed didn't fix the issue. Making the sys_user table extensible did. My understanding of cross-scope privilege is that it is a runtime protection, not design time. The issue as described is a design time issue, which is why I was surprised that adding the privilege fixed the issue. Again, it appears that it does not, unfortunately.

It looks like you can not reference a system table (sys_<tablename>) from a scoped application unless you have admin access, or that system table is configured to be extensible. Note that there are some system tables that are extensible out-of-the-box, like Reports (sys_report). This behavior may be intended. Will find out.

[vkachineni]

Dave, 

I am trying to use the table 'sys_data_source' in a scoped application. I am creating a Record producer to insert rows in to this 'sys_data_source' table.

How do I get this table show up in the tables dropdown

This is a scoped application