Need to implement the goal is to make database in addition to the system to other users can modify the table structure, can only be subordinate to the space where the data in the table to add and delete,
Now by writing the trigger actually has achieved this requirement, but before that want to grant the select, insert, update, and delete on XXXXXX to yyyyyyy, theory because there is no alter permissions, should be able to more convenient to implement the requirements of, result along while also didn't understand the concrete should be how to deal with, also, every brother please grant instruction
CodePudding user response:
Users on their tables under the schema of the ALTER permissions, in addition to the DDL triggers, no way out,Or you can build a user alone, not to give the user login permissions (no connect role authorization or the create session system permissions), then the table creation under the schema of the user, and then give other users select, insert, update, delete and other permissions,