CREATE TABLE [dbo].[ft_Test] AS FILETABLE ON [PRIMARY] FILESTREAM_ON [FileTable]
WITH
(
FILETABLE_DIRECTORY = N'ft_Test', FILETABLE_COLLATE_FILENAME = Cyrillic_General_CI_AS
)

CREATE USER [test_login] FOR LOGIN [test_login] WITH DEFAULT_SCHEMA=[dbo]

CREATE ROLE [rl_viewFileTable]

CREATE PROCEDURE [dbo].[viewFileTable]
AS
BEGIN
	SET NOCOUNT ON;

SELECT *
  FROM [test_1].[dbo].[ft_Test]

select Id = MAX([path_locator])
from [ft_Test]
where [path_locator].GetAncestor(1) = hierarchyid::GetRoot() 

INSERT INTO [dbo].[ft_Test]
           (
           [name]
           ,[is_directory]
           
          )
     VALUES
           ('тест1'
		   ,1)

  select USER_NAME()
END