Re: call a stored procedure

From: Morten <morten_at_kikobu.com>
Date: Wed, 20 Feb 2002 18:19:20 +0100
Message-ID: <3C73DA98.2000702@kikobu.com>

Fleury Marcel wrote:
> Hello,
> I would like to know if it is possible to call a stored procedure from
> tool like Sql*Plus ?
> Or is it only possible trough an application ?
>
> The goal is to prevent users that can directly access a DB using tools
> to run stored procedures.

Woops, missed your 2 last lines. Using Oracle you can accomplish what you wish by creating synonyms in a separate tablespace and give different grants to the tablespace users.

Morten Received on Wed Feb 20 2002 - 11:19:20 CST