Need help writing a SQL Script

Im attempting to write a script to add specific permissions to tables each
morning.
The problem is I have a database that gets purged each morning along with
the tables, and any permissions I have set for a user is also purged.
My user name is "workflow" with only public rights. In the database, users
"workflow " has select permissions to three tables which are FMS_Acct,
APS_Vendor, APS_Master.
If anyone can assist with the proper SQL that restorse the permissions would
be of great assistance.
Thank you in advance
RobertYou mean something like:
GRANT SELECT ON FMS_Acct TO workflow
"robert_at_cbb" wrote:
> Im attempting to write a script to add specific permissions to tables each
> morning.
> The problem is I have a database that gets purged each morning along with
> the tables, and any permissions I have set for a user is also purged.
> My user name is "workflow" with only public rights. In the database, users
> "workflow " has select permissions to three tables which are FMS_Acct,
> APS_Vendor, APS_Master.
> If anyone can assist with the proper SQL that restorse the permissions would
> be of great assistance.
> Thank you in advance
> Robert|||Yes thank you
"Jack" wrote:
> You mean something like:
> GRANT SELECT ON FMS_Acct TO workflow
> "robert_at_cbb" wrote:
> > Im attempting to write a script to add specific permissions to tables each
> > morning.
> >
> > The problem is I have a database that gets purged each morning along with
> > the tables, and any permissions I have set for a user is also purged.
> >
> > My user name is "workflow" with only public rights. In the database, users
> > "workflow " has select permissions to three tables which are FMS_Acct,
> > APS_Vendor, APS_Master.
> >
> > If anyone can assist with the proper SQL that restorse the permissions would
> > be of great assistance.
> >
> > Thank you in advance
> > Robert