salix/db/routines/vn/views/role.sql

9 lines
275 B
MySQL
Raw Permalink Normal View History

2024-08-20 08:06:10 +00:00
CREATE OR REPLACE DEFINER=`vn`@`localhost`
SQL SECURITY DEFINER
VIEW `vn`.`role`
AS SELECT `account`.`role`.`id` AS `id`,
`account`.`role`.`name` AS `name`,
`account`.`role`.`description` AS `description`,
`account`.`role`.`hasLogin` AS `hasLogin`
FROM `account`.`role`