/* * admin.sql -- PostgreSQL commands for creating the RADIUS user. * * WARNING: You should change 'localhost' and 'radpass' * to something else. Also update raddb/sql.conf * with the new RADIUS password. * * WARNING: This example file is untested. Use at your own risk. * Please send any bug fixes to the mailing list. * * $Id: 26d08cae41c788321bdf8fd1b0c41a443b2da6f4 $ */ /* * Create default administrator for RADIUS */ CREATE USER radius WITH PASSWORD 'radpass'; /* * The server can read any table in SQL */ GRANT SELECT ON radcheck TO radius; GRANT SELECT ON radreply TO radius; GRANT SELECT ON radgroupcheck TO radius; GRANT SELECT ON radgroupreply TO radius; GRANT SELECT ON radusergroup TO radius; /* * The server can write to the accounting and post-auth logging table. */ GRANT SELECT, INSERT, UPDATE on radacct TO radius; GRANT SELECT, INSERT, UPDATE on radpostauth TO radius;