21 Jan
2013
21 Jan
'13
2:59 p.m.
I have created a separate schema and user as follows: echo "CREATE USER \"tapomay\" WITH PASSWORD '~!@#$' NAME 'Ext User' SCHEMA \"sys\";" | mclient -d my_db echo "CREATE SCHEMA \"test_schema\" AUTHORIZATION \"tapomay\";" | mclient -d my_db echo "ALTER USER \"tapomay\" SET SCHEMA \"test_schema\";" | mclient -d my_db When logged in as "tapomay", I am able to execute curdate() but can't execute date_to_str(). I can run date_to_str() when logged in as the super user monetdb. There could be many other such utility functions. How do I enable all of them for the new user "tapomay". Regards, Tapomay.