Register Table Issue Options

[victoryismine]

Hi All,

I have created table in my database(sqlserver) and i have registered and updated permissions on that table using IDQL.

I'm able to see my table in registered table list but when i'm trying to execute select * from dm_dbo.mytablename; it is showing the following error:

Error occured during query execution :[DM_QUERY2_E_TABLE_NOT_FOUND]error: "The database table or view was not found in the database. Error from the database was: ' -- The database object is invalid -- STATE=S0002, CODE=208, MSG=[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.regtab'.

any suggestions,how to rectify it.

Thanks In Advance

Prasanthi

[hicham]

I'm not using SQLServer very often but I think that with SQLServer, you have to use "dbo" as the docbase owner alias and not "dm_dbo". Also, when you registered the table, where you logged in as the docbase owner. If not, it's safer to qualify the table name with docbase owner when you register it.

Hicham

[victoryismine]

I'm not using SQLServer very often but I think that with SQLServer, you have to use "dbo" as the docbase owner alias and not "dm_dbo". Also, when you registered the table, where you logged in as the docbase owner. If not, it's safer to qualify the table name with docbase owner when you register it.

Hicham

Thanks Hicham for the reply...
I have tried both the ways
1. using dbo instead of dm_dbo
2. Login with the docbase owner for registering the user

but i'm getting the same error...

[hicham]

So it appears that the docbase owner does not own that table. As which user did you create it in SQLServer? You have to use the same user when you register the table. the table_owner attribute of the dm_registered object should be set to that user.

If you only use the table with this docbase, I suggest that you create the table in the same schema as the docbase itself and register it as the docbase owner. Makes things simpler.

Hicham

[mgrootsch]

From the DQL reference (6.5sp2):

Access to a registered table is controlled by the object‑level permissions and table permits
defined for the table’s dm_registered object. The object‑level permissions must give
you at least Browse access to the dm_registered object and the table permits must give
you permission for the operation that you want to perform. For example, if you want
to update a table, the table permits must grant you DM_TABLE_UPDATE permission.
Table permits are defined for three user levels: owner, group, and world. (For complete
information about table permits and Documentum security, refer to the Content Server
Administration Guide.)

Additionally, the user account under which Content Server is running must have the
appropriate RDBMS permission to perform the requested operation on the specified
table. (The actual name of this permission depends on your RDBMS.) For example, if
you want to update the table, the server account must have permission in the RDBMS
to update the table.

All three of these conditions must be met to gain access to a registered table. Even if a
user has permission to access the underlying table through the RDBMS, the user will not
have access through DQL unless the object‑level permissions and table permits on the
dm_registered object permit access. Similarly, a user might have the correct object‑level
permissions and table permits, but if the server’s user account in the RDBMS does not
have permission, then access is denied.

[johnnygee_va]

What was your register DQL statement?

Hi All,

I have created table in my database(sqlserver) and i have registered and updated permissions on that table using IDQL.

I'm able to see my table in registered table list but when i'm trying to execute select * from dm_dbo.mytablename; it is showing the following error:

Error occured during query execution :[DM_QUERY2_E_TABLE_NOT_FOUND]error: "The database table or view was not found in the database. Error from the database was: ' -- The database object is invalid -- STATE=S0002, CODE=208, MSG=[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'dbo.regtab'.

any suggestions,how to rectify it.

Thanks In Advance

Prasanthi

[victoryismine]

What was your register DQL statement?

register table dm_tablename(columnname datatype,....);

update dm_registered object
set world_table_permit=15,
set owner_table_permit=15,
set group_table_permit=15
where object_name='tablename';

[johnnygee_va]

register table dm_tablename(columnname datatype,....);

update dm_registered object
set world_table_permit=15,
set owner_table_permit=15,
set group_table_permit=15
where object_name='tablename';

If your table name is 'tablename', then your register DQL should be this:

register table dbo.tablename(columnname datatype,....);