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