Re: [GENERAL] creating tables in tablespace

Tiffany Thang writes: > Thanks Tom. As the superuser, I'm able to create the table in the specific > tablespace. Does myuser require additional privileges? Yes, USAGE on the tablespace if memory serves (check the GRANT man page for details). > My aim is to be able to

Re: [GENERAL] creating tables in tablespace

Thanks Tom. As the superuser, I'm able to create the table in the specific tablespace. Does myuser require additional privileges? My aim is to be able to create table in a specific tablespace (in this case, mytablespace) by default without having to explicitly specific one. I would think that is

Re: [GENERAL] creating tables in tablespace

Tiffany Thang writes: > According to the documentation, a table can be created in a specific > tablespace by performing the following: > 1. Specify the tablespace parameter in the create database statement. > 2. Specify the tablespace parameter in the create table

[GENERAL] creating tables in tablespace

Hi, I'm not able to create tables in a specific tablespace. I'm not sure what I have missed. According to the documentation, a table can be created in a specific tablespace by performing the following: 1. Specify the tablespace parameter in the create database statement. 2. Specify the tablespace