Re: Granting privileges thru a role Vs. Granting them directly.
From: Michael Krolewski <vandra_at_u.washington.edu>
Date: 1998/03/19
Message-ID: <35121B1F.E1D7C9D4_at_u.washington.edu>#1/1
Date: 1998/03/19
Message-ID: <35121B1F.E1D7C9D4_at_u.washington.edu>#1/1
I think a really great reason is if you need to drop tables
occassionally (it happens)
If you grant access to each user, when a table is dropped, you have to
re-establish
each users grants. If it is a role, you need to re-establish the access
for the role only.
Mike Krolewski
kunsha wrote:
> What are the implications of using one over the other.
> I know that they can be different. However, logically, I
> do not see a reason why this should be.
>
> Any clarification on this would be greatly appreciated.
>
> JV.
Received on Thu Mar 19 1998 - 00:00:00 CET