register table and update registered table object permission

– For example:

//create table
CREATE TABLE RT_CENTERS

(CENTER_ID    NUMBER, CENTER_NAME  VARCHAR2(60 BYTE))

//register table

– REGISTER TABLE dm_dbo.rt_centers

( CENTER_ID INT, CENTER_NAME CHAR(60) ) ;

Go;

//update registered table permission

– update dm_registered object set owner_table_permit = 15 set group_table_permit = 15 set world_table_permit = 15 set world_permit = 3  where table_name = 'rt_centers ‘

//permission value explaination

– You need to give the permission to the users to access the registered tables.  The values for various permission levels are as follows  0 (None): No access 1 (Select): The user can retrieve data from the registered table 2 (Update): The user can update existing data in the registered table 4 (Insert): The user can insert new data into the registered table 8 (Delete): The user can delete rows from the registered table If a user wants update and insert permissions the value should be 2+4 = 6 , The repository owner also should have the same level of permission in the underlying database to grand those permission to those users.