-- Conversion failed when converting the varchar value '08:12' to data type int

-- Conversion failed when converting the ****** value '******' to data type ******

create table dbo.Test114 (ID int not null)
GO
create VIEW dbo.TestUid with VIEW_METADATA, SCHEMABINDING
AS
  SELECT ID
  FROM   dbo.Test114
  WHERE  ID = SUSER_ID()
GO
create view dbo.TestView114 with VIEW_METADATA
as
  select Test114.ID, TestUid.ID as TST
  from dbo.Test114
       left join dbo.TestUid on TestUid.id>0
GO
grant all on dbo.TestView114 to public 
GO
BEGIN TRY
  insert into dbo.TestView114(ID) values ('4:23')
END TRY
BEGIN CATCH
  print ERROR_MESSAGE();
END CATCH;
exec as user='some_not_admin_user'; -- Заменить на любого пользователя без прав администратора, но с доступом к базе
  BEGIN TRY
      insert into dbo.TestView114(ID) values ('4:23')
  END TRY
  BEGIN CATCH
    print ERROR_MESSAGE();
  END CATCH;
revert

drop view TestView114
drop view TestUid
drop table Test114

(0 rows affected)
Conversion failed when converting the varchar value '4:23' to data type int.

(0 rows affected)
Conversion failed when converting the ****** value '******' to data type ******.

dbcc tracestatus (3625)

TraceFlag  Status   Global  Session
----------  --------  -------  -------
3625        0	      0        0

(0 rows affected)
Conversion failed when converting the varchar value '4:23' to data type int.

(0 rows affected)
Conversion failed when converting the ****** value '******' to data type ******.

create table dbo.Test114 (ID int not null)
GO
create VIEW dbo.TestUid
AS
  SELECT ID
  FROM   dbo.Test114
  WHERE  ID = 1
GO
create view dbo.TestView114
as
  select Test114.ID, TestUid.ID as TST
  from dbo.Test114
       left join dbo.TestUid on TestUid.id>0
GO
grant all on dbo.TestView114 to public 
GO
CREATE LOGIN TestUser123 WITH PASSWORD = 'TestPassword!123';  
CREATE USER TestUser123 FOR LOGIN TestUser123; 
-- ----------------------------------------------------------------------------
BEGIN TRY
  insert into dbo.TestView114(ID) values ('4:23')
END TRY
BEGIN CATCH
  print ERROR_MESSAGE();
END CATCH;
exec as user='TestUser123';
  BEGIN TRY
      insert into dbo.TestView114(ID) values ('4:23')
  END TRY
  BEGIN CATCH
    print ERROR_MESSAGE();
  END CATCH;
revert

drop view TestView114
drop view TestUid
drop table Test114
drop user TestUser123
drop login TestUser123