Row Level Permission on multiple tables in Db2
-1
votes
1
answer
58
views
If there are 3 tables that have foreign key relationship and I am giving row level permission on 1 table does that permission also apply to the other 2 tables automatically? Or do I need to give row level permission on all the 3 tables separately .
for eg
Table 1
Asia India
Newyork US
Table 2
nagpur india orange
NJ US liberty
table3
xxxx nagpur yyyy
zzzz NJ ffff
now if I give row level permission asia user, does it implies on table 2,3
Asked by singlas
(1 rep)
Jan 19, 2024, 07:20 PM
Last activity: Feb 4, 2024, 08:40 AM
Last activity: Feb 4, 2024, 08:40 AM