Re: Procedures and rights

From: <syakobson_at_my-dejanews.com>
Date: Tue, 28 Jul 1998 02:41:36 GMT
Message-ID: <6pjdp0$b3q$1@nnrp1.dejanews.com>

In article <35BC5887.D650F237_at_erp-jena.de>, Sveta Hochsattel <s.hochsattel_at_erp-jena.de> wrote:
> Is it possible to grant any rights to a stored procedure ?
>

You can not grant privileges directly to stored procedure. However, stored procedure is always executed under its owner's schema and therefore has all privileges granted directly (not via role - roles are ignored for stored objects) to stored procedure owner. So by granting a privilege directly to a user you are, in fact, allowing any stored procedure owned by that user to perform any operation associated with that privilege.

Solomon Yakobson.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Mon Jul 27 1998 - 21:41:36 CDT