admin管理员组

文章数量:1400125

I'm currently working on an application and want to use some user management. I already queried the apex_workspace_apex_users table and would like to edit/delete it by an interactive grid (I'm workspace admin and gave the application the permission to modify the workspace repository) but I get 41900 privilege error when I try to do anything (like changing username or something like that). What could be the problem?

I'm currently working on an application and want to use some user management. I already queried the apex_workspace_apex_users table and would like to edit/delete it by an interactive grid (I'm workspace admin and gave the application the permission to modify the workspace repository) but I get 41900 privilege error when I try to do anything (like changing username or something like that). What could be the problem?

  • oracle-apex
  • user-management
Share Improve this question asked Mar 25 at 14:48 Máté Apáti-NagyMáté Apáti-Nagy 1
Add a comment  | 

1 Answer 1

Reset to default 1

The APEX_% objects are the APEX data dictionary views (they're not tables, but views on top of the APEX internal objects). They can be used to query metadata information about the apex application. The data in those objects can only be manipulated by the APEX Engine itself - it is not supported and highly discouraged to update that data through dml. To manipulate the data outside of APEX, use the pl/sql APIs

One solution to your question is to use custom dml on the IG as explained in this question . Then in the pl/sql, use the API to update / create the users. (create user API, edit user API)

Note however, that in most APEX implementations, the users in the APEX tables are only used during development. User authentication and user management is usually done in external systems through the Authentication Scheme.

本文标签： Is it possible to updateeditdelete Apex workspace users from the application written in apexStack Overflow

版权声明：本文标题：Is it possible to updateeditdelete Apex workspace users from the application written in apex? - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1744188202a2594392.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。