#1142 - CREATE VIEW command denied to user 'ezyro_23572398'@'192.168.0.6' for table 'log_view'

domain filter.ezyro.com

I can not create a view , why ?
here is the SQL

CREATE VIEW log_view
(
id,
user_id,
log_date,
user_name,
team_name,
log_day,
log_time,
log_type
)
AS
select
log.id AS id,
log.user_id AS user_id,
log.log_date AS log_date,
users.user_name AS user_name,
teams.team_name AS team_name,
log.log_day AS log_day,
log.log_time AS log_time,
if((log.log_type = '1'),'Login','Logout') AS log_type
from ((log
left join users on
(
(log.user_id = users.id)
))
join teams on
(
(users.team_id = teams.id)
));

Comments

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!