Restrictions on the read and write permissions of tables by Documentum users

Source: Internet
Author: User

 

During project execution, users always find that the content displayed in Webtop is insufficient and want to see more data. This will inevitably directly read table data from the background database, the problem arises: 1) How do common users except the administrator can read the data in these tables? 2)How to deal with custom tables and views?

1. Set the read permission for common users for system forms

 

Due to user permission restrictions, normal users can only access forms already registered in da. to access other forms, perform the following operations:

1. log in with the superuser of administrator in Da and execute registered in dql for form registration. If the registration is successful, the system will report an ID.

For example:

Code
Register Table DBO. "dmi_package_s"
("R_object_id" Char ( 16 ),
"R_workflow_id" Char ( 16 ),
"R_act_seqno" Int ,
"R_port_name" Char ( 16 ),
"R_package_name" Char ( 16 ),
"R_package_type" Char ( 40 ),
"I _package_order" Int ,
"I _package_oprtn" Char ( 64 ),
"I _acceptance_date" date,
"R_package_flag" Int ,
"I _is_replica" Int ,
"I _vstamp" Int )
Key ("R_object_id ");

2. Execute the access permission of the registry list in the background database.

Update Dm_registered_sp
Set Owner_table_permit =   ' 15 ' ,
Group_table_permit =   ' 15 ' ,
World_table_permit =   ' 15 '
  Where   Object_name   =   ' Dmi_package_s ' ; -- The ID r_object_id = * ID * of the corresponding feedback can also be executed here *

 

Here we willDmi_package_sAll the read and write permissions are granted. Therefore, you can set this parameter to 15, which can be determined based on your actual needs. Note: 15 = '000000', that is, all read/insert/update/delete permissions are granted.

2. Custom forms and views

The processing of Custom forms and views is the same as the preceding steps. The difference is that you need to create the corresponding table structure first in the background database. :)

 

 

 

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.