在甲骨文的Apex授权和用户角色？ [英] Authorization and user roles in Oracle Apex?

问题描述

所以顶点有工作区，它可以让您创建三种类型的用户 - 所有这些都是内部在性质组织。此外，似乎有没有办法关于APEX的个人网站开发商有用户只为他的网站。

So Apex has "workspaces", which let you create users of three types - all of which are internal to the organization in nature. Also, there seems to be no way for a developer of an individual site on Apex to have "users" just for his site.

我缺少的东西吗？

我需要能有外部的（业务）的用户能够以访问只是网站的某些功能，例如，会计只能看到网页A和B，而管理人员可以看到A，B和C

I need to be able to have external (business) users to be able to get access to just some features of the site, for example, accounting can only see pages A and B while executives can see A,B, and C.

我需要有几批人有不同的访问级别，能力。

I need to have ability to have several groups of people with difference degrees of access.

可这只能通过创建工作空间/组做了什么？或者可以说是对刚刚我的网站内部完成？

Can this only be done by creating workspaces/groups? Or can that be done internally on just my site?

推荐答案

虽然APEX有一个内置的称为组我必须承认，我从来没有用过它的用户管理理念，和文档的快速过目不让我清楚如何使用这些控制访问（但见汤姆的回答这里的）。

Although APEX has a built-in user management concept called "Groups" I must confess I have never used it, and a quick perusal of the documentation doesn't make it clear to me how you use these to control access (but see Tom's answer here for that).

您可能需要在数据库中创建用户/角色表，并使用这些与APEX授权计划相结合，以控制对页面的访问。类型的单一授权方案PL / SQL函数返回布尔可能与函数体中创建：

You will probably need to create user/role tables within your database and use these in conjunction with APEX Authorization Schemes to control access to pages. A single Authorization Scheme of type "PL/SQL Function returning Boolean" could be created with the function body:

return my_auth_pkg.is_authorized (p_user    => :app_user,
                                  p_app_id  => :app_id
                                  p_page_id => :app_page_id);

您会然后实现包来查找用户的权限，并决定是否返回TRUE或FALSE为应用程序和页面ID。

You would then implement the package to look up the user's privileges and decide whether to return TRUE or FALSE for the application and page id.

另外，你可以只执行SQL查询访问直接在授权方案：

Alternatively you could just perform the SQL to check for access directly in the Authorization Scheme:

（NBuser_roles和role_pages的名字，我发上来，重新present的您的表）

(NB "user_roles" and "role_pages" are names I made up, to represent your tables)

这篇关于在甲骨文的Apex授权和用户角色？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！