Re: Getting 'Insufficient Privileges' error. Why?

Brad Murray <BradMurray_at_SeeSignatureIfThere.com> wrote in article <MPG.f254af1bd183e669898ca_at_news>...
> In article <01bd1fbd$91d6dee0$65bbcdcf_at_AGDEV001.AGDEV>,
> jjames_at_crystalconsulting.com said...
> If you are not having this problem over an ODBC connection
> then you may actually not have the admin option set on the grants to the
> account you are trying to grant from.
>

Thanks for the feedback Brad. I had thought that the admin option was used to allow the user 'providing' the privilege to another to also enable the receiver of the privilege to then ''pass' that privilege onto others. You seem to be implying that you need the admin option in order to just 'provide' the privilege to others (vs. just yourself?) Is that true? Besides that, I did find a way to deal with my problem. I created another user to which I assigned a DBA role, (I don't think it had an admin option), then used that user to assign table privileges to the 'medical' user. It worked OK! Received on Tue Jan 13 1998 - 00:00:00 CET