Saturday, November 14, 2009

Guest usage of Rdbhost accounts

There is a handy way to provide other people read-only access to your Rdbhost database.

If you have enabled the 'r'-role, and given it reasonable (ie: only SELECT) permissions on the tables, you can allow other people to access your database using that role.

Just use the url for the rdbadmin page, and append the 'r'-role name to the url, with a '?'.

For example, our stackoverflow database is account 'db0000000767', and the 'r' role has been enabled and GRANTed appropriate privileges. The guest usage url is thus:
http://www.rdbhost.com/rdbadmin/main.html?r0000000767 .

Try it here.

There is no way to provide an authcode with the rolename, so it will not work for 's'-roles.

No comments:

Post a Comment