Re: 'create database' with ISQL + ONLINE

In article <2ehbdnINNmph@emory.mathcs.emory.edu>, Verschraegen Luc <Luc.Verschraegen@rug.ac.be> wrote: > > >On Fri, 10 Dec 1993, Jonathan Leffler wrote: > >> }Hi, >> }When you create a database from the isql menu, is there any possibility >> }to change the default dbspace? (I know, you can create the db with >> }a sql-statement like "create db in dbsace") But if you use the isql-menu >> }all databases will be created in the rootdb. I found no hints in the >> }manuals, maybe somone knows a solution! >> Using ISQL, you cannot specify the default dbspace. [stuff deleted] >In DBaccess, as far I know,the only way to ensure that a database is created >in the correct dbspace, is with the "Query-Language" menu option and >the SQL statement "CREATE database <dbname> IN <dbspace> ...." >Users who create a data base with the "Create" option from within the Database >menu in DBaccess create their database in the root dbspace. > >It would be nice if there was some possibility to: > (1) prevent users from creating a database in the root dbspace > and more > (2) ensure that certain users or group of users can only create databases > in specific dbspaces. I agree! That would be a very helpful feature. Especially in an educational environment, where you have some novice-users. The 'Online-Admintrators- Guide' recommended only 20 MB diskspace for the rootspace. In my opninion that's not enough. Maybe another question: Is there a possibility for an Online user to create a personal backup on a remote tape (which is different from the device-entry in the etc/tbconfig)? Olaf Hendel, Technische Universitaet Berlin/Germany Zentraleinrichtung Rechenzentrum (ZRZ) ======================================================================= | Einsteinufer 17 | PHONE : 030/314-23752 | | Sekr. E-N 50 | | | D-1000 Berlin 10 | INTERNET : hendel@zrz.tu-berlin.de | =======================================================================