. SQL Server Management Studio :
USE Postavki;
GO
CREATE VIEW PostDet.SUP_P
AS SELECT S, STATUS, CITY
FROM PostDet.tblS WHERE STATUS > 10;
. .
GRANT. Fred.
USE Postavki;
GO
GRANT SELECT (S,STATUS)
ON PostDet.SUP_P
TO [FS-64C67299CCAR\Fred];
Fred, :
1.SELECT STATUS FROM PostDet.SUP_P;
2.SELECT CITY FROM PostDet.SUP_P;
.
REVOKE.
.
.
T , , . , .
.
, , . , . , .
, , .
, , .
. :
USE Postavki;
GO
CREATE PROCEDURE PostDet.SUP_STAT @Rstatus INT
AS
BEGIN
SELECT * FROM PostDet.tblS WHERE STATUS > @Rstatus
END
.
, SQL Server, EXECUTE . EXECUTE Fred.
USE Postavki;
GO
GRANT EXECUTE ON PostDet.SUP_STAT
TO[FS-64C67299CCAR\Fred];
EXECUTE. .
Fred.
. : PostDet. SUP_STAT 10;
.
:
USE Postavki;
GO
DECLARE @Zstatus INT
SET @Zstatus = 20
EXEC PostDet. SUP_STAT @Zstatus;
DROP PROCEDURE.
DROP PROCEDURE name.
REVOKE. DENY.
Fred SUP_STAT.
.
: , , , . , : EXECUTE SELECT.