Patent attributes
Access to an individual tenant's data within a multi-tenant relational database architecture is provided, without unduly exposing data of other tenants. A list of accessible tables is presented to an authenticated individual, such as a developer. Specific information can be designated as sensitive and can be excluded from the information the developer can access. A specialized user interface provides secure point-and-click access to data by allowing selection of a set of higher-level data types to retrieve. Access to data from a related table can be enabled by providing a hyperlink that, when activated, retrieves a relevant record from the related table. Primary key values can also be rendered as hyperlinks that can activate a pop-up menu showing all tables that refer to that primary key value. In at least one embodiment, SQL queries are automatically constructed based on the user's selection of items from the pop-up menu.
