select * from role;
+-----+--------------------+
| rid | name               |
+-----+--------------------+
|   1 | anonymous user     |
|   2 | authenticated user |
+-----+--------------------+
2 rows in set (0.00 sec)




 select * from permission;
+-----+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----+
| rid | perm                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | tid |
+-----+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----+
|   1 | play audio, view download stats, view buddy lists, use default fckeditor, create forum topics, view job, access content, view resume, access user profiles, administer users, access video, play video, vote on content                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 |   0 |
|   2 | access news feeds, administer news feeds, download audio, play audio, view download stats, edit own blog, access bookmarks, maintain buddy list, view buddy lists, access comments, post comments, post comments without approval, use default fckeditor, create forum topics, edit own forum topics, edit own job, view job, access feeds, create feed, edit own feeds, edit own news items, manually leech data, access content, create pages, edit own pages, access portal, view resume, administer search, search content, use stock, access user profiles, administer users, access video, administer video, create video, edit own video, play video, insert custom fields, upload video files, vote on content, administer custom weather block |   0 |
+-----+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----+
2 rows in set (0.00 sec)