1/* 2 * admin.sql -- PostgreSQL commands for creating the RADIUS user. 3 * 4 * WARNING: You should change 'localhost' and 'radpass' 5 * to something else. Also update raddb/mods-available/sql 6 * with the new RADIUS password. 7 * 8 * WARNING: This example file is untested. Use at your own risk. 9 * Please send any bug fixes to the mailing list. 10 * 11 * $Id: 884aa5a5ede1cdc37c55c7d06d52410b3826e135 $ 12 */ 13 14/* 15 * Create default administrator for RADIUS 16 */ 17CREATE USER radius WITH PASSWORD 'radpass'; 18 19/* 20 * The server can read any table in SQL 21 */ 22GRANT SELECT ON dhcpreply TO radius; 23GRANT SELECT ON dhcpgroupreply TO radius; 24GRANT SELECT ON dhcpgroup TO radius; 25 26GRANT USAGE, SELECT ON SEQUENCE dhcpgroupreply_id_seq TO radius; 27GRANT USAGE, SELECT ON SEQUENCE dhcpreply_id_seq TO radius; 28GRANT USAGE, SELECT ON SEQUENCE dhcpgroup_id_seq TO radius; 29