Shared tables

Hi!
Id like to create a shared schema like the following.

Schema shared{
shared table a
shared table b
}

Schema user1{
shared table a
shared table b
private table c
}

Schema user2{
shared table a
shared table b
private table c
}

user should not be able to create private table a or b since they already exists in the shared schema.
user should access shared table a and b as just a or b instead of shared.a or shared.b
if trying to create shared table c when private table c exist deny create (or rename private table c).
If it's possible for the users to create table in there own schema user 1 table c is not the same table as user 2 table c.

Access to the shared schema should be granted or denied as usual for each user or role.

Tia
--
Roland Carlsson
Certified Java programmer
Skövde
Sweden

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Oct 21 1999 - 06:21:20 CDT