Could you use SQL standards based authorization to deny CREATE TABLE privileges to everybody except the database owner, and then make people ask the owner to create tables for them?
-- Lefty On Thu, Apr 2, 2015 at 4:44 PM, Chen Song <chen.song...@gmail.com> wrote: > Got it. Thanks. > > On Thu, Apr 2, 2015 at 11:29 AM, Alan Gates <alanfga...@gmail.com> wrote: > >> When someone creates a table in your 'abc' database it should by default >> be in '/my/preferred/directory/_tablename_'. However, users can specify >> locations for their tables which may not be in that directory. AFAIK >> there's no way to prevent that. >> >> Alan. >> >> Chen Song <chen.song...@gmail.com> >> April 2, 2015 at 8:15 >> I have a dumb question on DDL statement "create database" >> >> Say if I create a database >> CREATE DATABASE abc >> LOCATION '/my/preferred/directory'; >> When later on someone needs to create a table in this database, is there >> a way to force the location of the table to be under >> /my/preferred/directory? >> >> I searched around but could not find a way to enforce this. >> >> >> -- >> Chen Song >> >> > > > -- > Chen Song > >
