Blas Rodriguez Somoza : > 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.
It is not only CREATE SCHEMA, but the ability for other users to create objects in this schema. This creation of tables is now restricted to the user with the name the namespace has. The create schema and those things belonging to it are part of our long term planning. Sorry, not to be able to give an answer which will help you within the next future. Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
