Re: rootdbs protection

In <1rp15hINNga7@emory.mathcs.emory.edu> jparker@hpbs2561.boi.hp.com (Jack Parker) writes: >Is there someway to prevent users from creating databases on your engine? No. Which has always annoyed me. I tried to get it registered as a Feature Request when I was at Informix, but I don't think it made it thru the red tape. ORACLE supports the syntax: GRANT RESOURCE ON rootdbs [ (bytes) ] TO idiot; which would solve the problem quite nicely, and I for one would be quite happy to accept the implied performance overhead at extent creation time (assuming that the "quota" belonged to the owner of the table, not the user that caused the next extent to be allocated). graeme -- Disclaimer: The author's opinions are his own, and not necessarily those of Pyramid Technology Ltd. or Pyramid Technology Inc. --------------------------------------------------------------------------- -m------- Graeme Sargent Voice: +44 (0)252 373035 ---mmm----- Senior Database Consultant Fax : +44 (0)252 373135 -----mmmmm--- Pyramid Technology Ltd. Telex: Tell who??? -------mmmmmmm- Farnborough, Hants GU14 7PL Email: graeme@pyra.co.uk --------------------------------------------------------------------------- We have the technology. The tricky bit is learning how to use it.