Register a table

1) Create a table in the database
2) Register using DA

For E.g:

DQL> REGISTER TABLE dm_dbo.MLTC_BUSINESS_DOC_TYPE_WEB(BDT_ID INT, BDT_NAME CHAR(255), BDT_DESCRIPTION CHAR(255), CLASS_NAME CHAR(64), HIGHEST_LEVEL_FOLDER CHAR(255), LOWEST_LEVEL_FOLDER CHAR(255));

new_object_ID
=============

190049e0803f9
(1 rows affected)

Update reg table values.

DQL> update dm_registered objects set group_permit= 15 where r_object_id = '190049e0803f96d0';

objects_updated
===============

1
(1 rows affected)
DQL> update dm_registered objects set world_permit= 7 where r_object_id = '190049e0803f96d0';

objects_updated
===============

1
(1 rows affected)
DQL> update dm_registered objects set owner_table_permit= 7 where r_object_id = '190049e0803f96d0';

objects_updated
===============

use this DQL to grant proper permission to your table
update dm_registered object
set owner_table_permit = 15,
set group_table_permit = 15,
set world_table_permit = 15
set owner_permit =7,
set group_permit =5,
set world_permit=3
where object_name = 'AddressBook'
go

This should give proper permission to your registered table. if you want you can change the table_permit from 15 to whatever u like.

To get the install owner name. use this DQL, sometimes its handy.

select user_name from dm_user where user_name = 'dm_dbo'