Access inbetween databases

Database
SAP
Enthusiast

Access inbetween databases

Hi ,

1. Please help me with the GRANT statement :-

An owner referenced by user does not have SELECT access to 'DATABASE'

2. also , what is the DBC table to verify if the access has been issued .

1 REPLY
Enthusiast

Re: Access inbetween databases

SAP,

A precise answer could be given if you include code or a description of what your doing.

Your example would be similar to a View database needing "select with grant option" on the base table database for the view to be accessed by a user. The user would only need to be granted select on the view database or database.viewname.

You can see the accessrghts held for user or database in dbc.allrightsv, or for Roles in dbc.allrolerightsv.

Rglass