Post reply

Is there a SCHEMA view to return routine privileges

  • October 1, 2004 at 11:54 pm

    #525112

    It seems that there is no INFORMATION_SCHEMA view for routine privileges. Other ways to retrieve this information are: using the sysprotects table or using the sp_helprotect stored procedure.

    Razvan

  • October 4, 2004 at 1:47 am

    #525152

    I had a horrible feeling this was the case.

    Masny thanks.


    ---------------------------------------
    It is by caffeine alone I set my mind in motion.
    It is by the Beans of Java that thoughts acquire speed,
    the hands acquire shaking, the shaking becomes a warning.
    It is by caffeine alone I set my mind in motion.

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply