|
Home > Archive > MS SQL Server > June 2005 > Need help writing a SQL Script
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Need help writing a SQL Script
|
|
| robert_at_cbb 2005-06-23, 1:23 pm |
| 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
| |
|
| 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
| |
| robert_at_cbb 2005-06-24, 11:23 am |
| Yes thank you
"Jack" wrote:
[color=darkred]
> You mean something like:
>
> GRANT SELECT ON FMS_Acct TO workflow
>
> "robert_at_cbb" wrote:
>
|
|
|
|
|