The current security model provides an option for non-full access users to modify layouts and scripts. But it's difficult for such users to work with layouts and scripts without the ability to explore the underlying schema. Ideally this idea would allow authorized users to do all the following WITHOUT LOCKING ANY TABLES:
1. View all Manage Database tabs (Tables, Fields, Relationships)
2. View the options for any field, including calculations
3. View relationship details
Such users would NOT be able to:
1. Modify schema
2. Modify security
Another benefit of this idea is that more users could be externally authenticated since they wouldn't need [Full Access] accounts.