Re: WebDB: show_parms
Date: Tue, 04 Jan 2000 22:14:18 GMT
Message-ID: <_guc4.1957$E92.14197_at_afrodite.telenet-ops.be>
Don't forget Webdb uses stored procedures!
And stored procedures take by default the privileges of the owner of the
stored procedures.
This means you can protect all your data, only granting the acces to the
procedure owners,
afterwards you'l just have to grant execute on the procedure to the users or
roles (is provided as a panel in webdb).
This means you can create all accessing users just granting them create
session privilege and of course the wanted procedures.
Gorm Larsen <gorm_larsen_at_jyde.dk> schreef in berichtnieuws
MPG.12dc45dbdab4895c989763_at_valhal.vestjyde...
> In article <MPG.12db4477f94b8f18989762_at_valhal.vestjyde>,
> gorm_larsen_at_jyde.dk says...
> > Connected as Web_Demo, Web_Demo_Admin or Web_Demo_Public I get an error
> > WWV-10600 Insufficient privileges in Check_Object_Privilege when i enter
> CUT
> > What am I missing ?
>
> Problem solved. The user Web_Demo needed to be granted Select in
> privilege in its own schema. :-(
>
Received on Tue Jan 04 2000 - 23:14:18 CET