InterSystems Ideas

Have an idea, suggestion, or something that doesn’t work as expected in InterSystems products or services? Share it here on the InterSystems Ideas Portal.

The Ideas Portal is where community members can propose improvements, report bugs, and help influence the product roadmap across InterSystems products and the overall developer experience. 22% of submitted ideas are implemented by InterSystems or members of the Developer Community.

💡 Ideas and bugs are both welcome, no matter how big or small. You can submit feature requests, usability improvements, workflow suggestions, and bug reports. Whether you’re an experienced expert or just getting started, your fresh perspective is valuable.

🛠️ About bugs and fixes. If you have access to InterSystems WRC, please submit bugs there for immediate action. Bug reports submitted through the Ideas Portal are reviewed and tracked, but do not guarantee immediate resolution.

Start by sharing what could be better - the community and our teams will help take it from there.

Add a new idea Subscribe
Status Already exists
Categories InterSystems IRIS
Created by Sylvain Guilbaud
Created on Sep 11, 2023

RELATED IDEAS

Manage SQL accesses to all or some schemas in a database, instead of managing it a the tables level.

Currently, the SQL privileges (SELECT, INSERT, UPDATE, DELETE) are managed at the tables level, which can be very tedious when you have to administer many roles in an organization, and need to keep them sync with a constantly evolving data models.
By managing privileges at the schemas level, will allow to give SELECT and other DML privileges to *all* or *several schemas* to a role|user, fixing the need to manually synchronize the new tables|views to the roles.

  • ADMIN RESPONSE
    Sep 25, 2023

    Thank you for posting the idea. According to information from experts, this functionality already exists.

  • Post comment
  • Sylvain Guilbaud
    Sep 11, 2023

    Thanks to Alexander Koblov for pointing me towards this feature that I simply hadn't thought of.

    Reply
  • Sylvain Guilbaud
    Sep 11, 2023

    Actually this feature is already available with IRIS through the GRANT ... ON SCHEMA ...

    Ex: GRANT SELECT ON SCHEMA data TO ROLE|USER

    And the cool thing is that as soon as your user has received a GRANT on a schema, when you edit afterwards the user in the Security Management portal, you can see on the SQL Tables tab all the tables appear as they are created


    Reply