Friday 19 December 2014

SQL - GRANT Access to Record

I want to grant SELECT, UPDATE, DELETE, or all of these to a record.

Fire up Data Mover:

  1. Application Designer > Go > Data Mover
  2. or
  3. \Pt848\bin\client\winx86\psdmt.exe
SET LOG C:\TEMP\GRANTLOG2014.LOG;

GRANT ALL ON SYSADM.PS_MYRECORDNAME TO myusername;

No comments:

Post a Comment