Можно ли сделать запрос, который будет выводить разную информацию в зависимости от пользователя которые используют sql server?

select SUSER_NAME()

SELECT firma.kodFirm, firma.nameFirm, firma.abbr, firma.sfera, firma.region, firma.nomDog, firma.dataDog, firma.kontract, firma.FIO, firma.doljnost, firma.tel, firma.adres, firma.sait, firma.EMail, firma.proces, firma.DataKontacta, firma.ОКомпании
FROM firma
WHERE (((firma.kodManager)="manager4"))
GROUP BY firma.kodFirm, firma.nameFirm, firma.abbr, firma.sfera, firma.region, firma.nomDog, firma.dataDog, firma.kontract, firma.FIO, firma.doljnost, firma.tel, firma.adres, firma.sait, firma.EMail, firma.proces, firma.DataKontacta, firma.ОКомпании;

SELECT firma.kodFirm, firma.nameFirm, firma.abbr, firma.sfera, firma.region, firma.nomDog, firma.dataDog, firma.kontract, firma.FIO, firma.doljnost, firma.tel, firma.adres, firma.sait, firma.EMail, firma.proces, firma.DataKontacta, firma.ОКомпании
FROM firma
WHERE firma.kodManager = (SELECT SUSER_NAME())
GROUP BY firma.kodFirm, firma.nameFirm, firma.abbr, firma.sfera, firma.region, firma.nomDog, firma.dataDog, firma.kontract, firma.FIO, firma.doljnost, firma.tel, firma.adres, firma.sait, firma.EMail, firma.proces, firma.DataKontacta, firma.ОКомпании;

CREATE TABLE dbo.users(
    user_id int IDENTITY(1,1) NOT NULL CONSTRAINT PK_users PRIMARY KEY CLUSTERED,
    user_login nvarchar(128) NOT NULL CONSTRAINT UQ_users UNIQUE,
    user_FIO nvarchar(200) NULL,
    dt_register date NULL,
    dt_connect datetime NULL,
    dt_exit datetime NULL,
    hello_text nvarchar(500) NULL
   )
GO

declare @user_id int
SELECT @user_id = user_id FROM dbo.users WHERE user_login=SUSER_NAME()
IF @user_id is null
   PRINT 'GO OUT, Anonymous'
ELSE BEGIN
   UPDATE dbo.users SET dt_connect=GETDATE() WHERE user_id=@user_id
   ...
END

-- Статический домен: (domen\manager4)
SELECT SUBSTRING(SUSER_NAME(), 7, 20)
 
-- Динамический
SELECT SUBSTRING(SUSER_NAME(), CHARINDEX('\', SUSER_NAME()) + 1, LEN(SUSER_NAME()) - CHARINDEX('\', SUSER_NAME()))

SELECT firma.kodFirm, firma.nameFirm, firma.abbr, firma.sfera, firma.region, firma.nomDog, firma.dataDog, firma.kontract, firma.FIO, firma.doljnost, firma.tel, firma.adres, firma.sait, firma.EMail, firma.proces, firma.DataKontacta, firma.ОКомпании
FROM firma
WHERE firma.kodManager = (SELECT SUBSTRING(SUSER_NAME(), 7, 20))
GROUP BY firma.kodFirm, firma.nameFirm, firma.abbr, firma.sfera, firma.region, firma.nomDog, firma.dataDog, firma.kontract, firma.FIO, firma.doljnost, firma.tel, firma.adres, firma.sait, firma.EMail, firma.proces, firma.DataKontacta, firma.ОКомпании;