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.
"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????
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: 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)
Re: Moving shared folder to new drive ... Wouldn't I have to recreate the permissions on the shares?...Jerold Schulman wrote: ... (microsoft.public.windows.file_system)
Re: View to drop or not? ... I recommend ALTERing over ... DROP and CREATE so you don't have to re-apply any permissions.... > do I have to drop and recreate it? ... > Thanks and Regards,... (microsoft.public.sqlserver.programming)
Re: restore deleted groups ... I would say that you should not recreate the group at all. ... You should perform an authorized AD Objects restore instead. ... Since you have already recreated the group and reassigning permissions to ... group to use the deleted group SIDs.... (microsoft.public.windows.server.active_directory)
