Re: Granting privileges thru a role Vs. Granting them directly.

>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.
>
>
>
One of the reasons for the difference is that views and stored procedures are stored in the database in compiled form. This means that the tables have already been parsed. If the access to the tables/views used in the views/stored procedures were granted via a role (which may change from one user to another), the performance gain is lost because the definition needs to be reparsed for each user, depending on which roles they have.

Dan Received on Sun Mar 22 1998 - 00:00:00 CET