-- Collection of code snippets by Arne Vajhøj 
-- (likely posted to comp.os.vms/INFO-VAX, INFO-TPU, MACRO32, eksperten.dk, newz.dk, LinkedIn or other place sometime between 1990 and now) 
USE test
GO
CREATE TABLE texttest (
    id INTEGER PRIMARY KEY,
    content NTEXT
)
GO
INSERT INTO texttest VALUES (1,N'abc')
GO
INSERT INTO texttest VALUES (2,N'def')
GO
SP_GRANTLOGIN 'ARNEPC3\IUSR_ARNEPC3'
GO
SP_GRANTDBACCESS 'ARNEPC3\IUSR_ARNEPC3'
GO
GRANT SELECT ON texttest TO [ARNEPC3\IUSR_ARNEPC3]
GO
