Re: user defined Role - HELP

Having to drop and recreate a table all the time is a bad practice. Why
can't you just truncate it? That said, once created and the permissions
properly set, you can have the permissions scripted out via SSMS. Reapply
those permissions each time the table is recreated.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"Charlie" <Charlie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:673ABCF9-DC4A-4C48-A918-653707196418@xxxxxxxxxxxxxxxx
I have a stored procedure that requires dropping a table and then recreating
it each time a user runs it. What / how do i set permissions to allow them
to run this one stored procedure????

.

Relevant Pages

  • Re: Cannot write to shared folder on W2K8 server
    ... After reading your latest post and Meinolf about how you cannot recreate my issues led me to try to recreate it myself. ... I created a new folder and share on C: and can write to it from my desktop. ... Which I still don't understand why it doesn't work especially if I had reapplied the share permissions and NTFS security. ... If that was the case, maybe removing the share and NTFS permissions, except for administrator, and then reapply the NTFS permissions, then the Share. ...
    (microsoft.public.windows.server.general)
  • Re: How to copy files with permissions plus the users from a stand alone server to another?
    ... folders with NTFS permissions beloning to the users. ... from the resource kit to export the users to a file and recreate them ... Directroy implies machines connected using Active Directory. ... alligator but does have the functionality to change ACLs from one SID to another ...
    (microsoft.public.windows.server.general)
  • Re: permissions resetting on a View
    ... you run the sp_refreshview it appears to keep the permissions on a view. ... If you really want to create or alter a view via a stored procedure you can ... "Terrell Miller" wrote in message ... > delete the view and recreate it? ...
    (microsoft.public.sqlserver.server)
  • Re: How to copy files with permissions plus the users from a stand alone server to another?
    ... folders with NTFS permissions beloning to the users. ... from the resource kit to export the users to a file and recreate them ... Directroy implies machines connected using Active Directory. ... alligator but does have the functionality to change ACLs from one SID to another ...
    (microsoft.public.windows.server.general)
  • Re: permissions for group policy??
    ... Even if you recreate the same name etc. the SID is different from the SID that is used on your profiles. ... So you have to set in every user profile folder the rights by hand for the recreated username with Full control as a minimum. ... By "re-creating" I had to recreate the user names, add permissions to ... administrators group tries to logon with their roaming profile. ...
    (microsoft.public.windows.group_policy)