Hello
To be compliant with SQL92 Entry a database need to include the create
schema statement, that SAPDB don't support, but I see all of the schema
functionalities in the database, and I'm curious about that, so I was
testing if SAPDB user concept match the SQL92 schema Concept.
I found that:
- There exits separated namespaces for each schema/user, and so it can exits
two tables with the same name on different users/schemas. This is what the
standard need.
- The SQL Statements allow the use of user/schema as part of the table name.
This also comply with the standard.
- User can use the tables in other's namespaces depending on the privileges.
Ok with the standard.
- There is no "create schema" Statement. This is the only part in the schema
standard that I don't see in SAPDB.
The create schema statement allows a user to create tables or other
database object in other user/schema namespace. For instance a database
administrator can create tables to store each user transactions in a
different table each one in a different namespace for security purposes,
allowing each user to query only its own transactions, without the need and
the risk to control it with a program or to assign priviliges, because each
user namespace is only accesible to the user and to the administrator.
The conclusion is that SAPDB has the functionalities and only lacks the
"create schema" statement.
Only Oracle, DB2, SQLServer, Sybase, Informix, Ingres, Mimer and
Frontbase support schemas, and no one of the open source databases support
it.
Regards
Blas Rodriguez Somoza.
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
