Thursday, September 22, 2022

SQL Server How to grant user

 USE [PS_STAGING]

GO

CREATE USER [svc_psstaging_feed] FOR LOGIN [svc_psstaging_feed]

GO



1> use ps_staging

2> go

Changed database context to 'PS_STAGING'.

1> create user svc_psstaging_feed for login svc_psstaging_feed

2> go

1> grant select on PSA_TimesheetByWeek to svc_psstaging_feed;

2> go

1>

No comments:

Post a Comment