1 Reply Latest reply: Jun 20, 2012 7:18 AM by 791885 RSS

    Schema configuration

    941776
      Hi

      As far as I know schema is just a layout of database and one DB can have as many schemas as needed.

      so, can there be more than one users for a schema?
      and can one user be owner of many schemas??

      Thanks!!
        • 1. Re: Schema configuration
          791885
          Hi Mohit,

          A user and a schema are pretty much the same. For each user you can give privileges to use objects owned by other users/schemas.

          This means that a user can access multiple schemas depending on the privileges given.

          Thanks

          Sander