Re: Multiple tablespacesI

On Mon, 22 Nov 2004 06:31:44 -0500, "Mark C. Stock" <mcstockX_at_Xenquery .com> wrote:

>yes, in oracle schemas are meant to be used that way -- the concept of user
>and schema are closely coupled
>
>however, in any RDBMS, you can't (or shouldn't) have a situation 'where no
>matter which user can select' unless you specifically set up permissions for
>those users.
>
>to accomplish what you describe in oracle, you probably want one user/schema
>as the owner for each dataset, one role per dataset as a target for
>permissions (GRANT SELECT, INSERT, etc) on that dataset, then accounts for
>each end-user that have appropriate system (ie, CREATE SESSION) and role
>privileges.
>
>++ mcs
>

First of all (I've forgotten this so far), thanks for anyone who is kind enough to help me/show me the right direction. I'm a application developer, and my boss thinks I know every DBMS (and its details) by heart (I absolutely don't !!) so my assignment was : Create an end-user application that supports Oracle/MS SQL Server/MySQL/...

In our application I have 1 main user which is the owner of the data. Each application user logs in with their own credentials. In each dataset, I already have 1,n role(s) so the issue of privileges will not be the isue.

So, given the info you gave me, I'll continue my search in the documentation/ng/google for schema, and try to create multiple schemas for that main user, and then try to assign enough privileges to the users so they can switch datasets.

Will keep you informd ;)

Thanks again,

Bram Received on Mon Nov 22 2004 - 06:21:20 CST