Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register


1
(click on this box to dismiss)

Is a class unique within a database?

In db_class, I can select classes (tables) along with their "owner". I reckon that "owner" and "user" are the same thing in the CUBRID database. Can the same class exist for several owners in the same database?


In other words: does the owner correspond to what other databases call a "schema", or are there no schemata in CUBRID databases?

link comment (0) accepted answer
asked 2 years ago
lukaseder
63
32 Answers
1

CUBRID does not support schema in the sense in which PostgreSQL or SQL Server use it. In that sense, a CUBRID database has only one schema.

Each table name is unique, the owner field in db_class points to the creator of that class. However you can grant access to other users to that table using the GRANT syntax.

You can use SHOW GRANTS to see authorizations. To see the users that have access to table t you can also write this:

 select owner.name from db_authorization where class t in grants;


link comment (1)
answered 2 years ago
ginarrbrik
516
2
  1. Since class = table, they should be unique in the database.
  2. The owner of the class is the creator of the class.
  3. Since there can be only one who can first create a table, the same class cannot exists in db_class for two or more owners.
  4. And the database can have only one schema.
link comment (1)
answered 2 years ago
dba
558
tagged




You are either using a very old browser or a browser that is not supported.
In order to browse cubrid.org you need to have one of the following browsers:



Internet Explorer: Mozilla Firefox: Google Chrome: