access

Database
Enthusiast

access

Hi,

 

How to grant complete access on database to batch user? The concern is batch job should not fail due to access request.

 

also, is there anyway to track about granted database to database access? beacuse jobs should not fail when access data from table which is present on other database. how to ensure database to database having all access rights?

 

Regards,

Sridharan

1 REPLY
Junior Contributor

Re: access

GRANT SELECT ON databasename TO username;

 

dbc.AllRightsV or dbc.AllRoleRightsV, TableName 'all'  indicates access on a database level