Re: schema privileges?

On Wed, 10 Nov 1999 05:30:13 GMT, "C. Ferguson" <c_ferguson_at_rationalconcepts.com> wrote:

Hai,
At the moment i am installing WebDB on a local PC, does anyone of you know how this works. I have problems with the configuration of the listener. I dont get access to WebDB itself too.

nico

>
>Hi,
> you could create a role, assign privleges to the role and grant the role to
>the users.
>The trick here though, is that if you grant create any table to the role, than
>assign the role to user1 and user2, not only will they be able to create
>tables in schema webdb_public, but also create tables in each others schema.
> Another approach would be to create stored procedures that create the tables
>in webdb_public, and then these procedures would be allowed to create only in
>the webdb_public schema, but this is also tricky because they have to be
>really dynamic...
>just some food for thought...
>
>cindy
>
>Verna Legaspi wrote:
>
>> Hello all,
>>
>> We're playing with WebDB and would like to have a schema that owns all the
>> components we create. What privileges would I need to grant users to be
>> able to create objects in this "webdb_public" schema?
>>
>> And what's the SQL for it? Is it correct that SQL such as:
>> GRANT CREATE TABLE TO webdb_public
>>
>> would only grant it to the user webdb_public? What if I want to grant
>> CREATE TABLE (and many other privs) on the webdb_public schema to several
>> users?
>>
>> TIA,
>> Verna
>
Received on Fri Nov 12 1999 - 02:49:57 CST