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.