SQL function as non-privileged user
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.
On Mon, Jan 21, 2013 at 06:59:55AM -0800, Tapomay Dey wrote:
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".
through schema.date_to_str(). Where schema is replaced by the schema in which the function is created (sys?, which is the default schema for the monetdb superuser).
Niels
Regards, Tapomay.
users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
participants (2)
-
Niels Nes
-
Tapomay Dey