RE: truncate table

From: Davy (Davy_at_discussions.microsoft.com)
Date: 06/22/04 

Date: Tue, 22 Jun 2004 09:07:01 -0700

you could wait for Yukon to come out. this gives you the option to create a stored procedure with a truncate table statement. You can then GRANT the stored procedure to be EXECUTED AS a login or role.

"stacey" wrote:

> Good idea. Thx...
> >-----Original Message-----
> >Hi,
> >
> >Truncate table permissions are NOT transferable. Only
> >table owners and dbo's have this permission.
> >
> >Perhaps, you could change table ownership.
> >
> >TIA
> >DeeJay
> >>-----Original Message-----
> >>Can you explicity grant access to truncate a specific
> >>table to a login id without giving dbo permissions on a
> >>database.
> >>
> >>I have a job that first truncates a table and then runs
> a
> >>dts job to import into that table. I do not want to
> give
> >>the account that runs the job any additional
> permissions
> >>than necessary.
> >>
> >>thanks..
> >>
> >>
> >>.
> >>
> >.
> >
>

Relevant Pages

  • Re: With in a SP Truncate dbo.table table-name permissions..
    ... TRUNCATE TABLE permissions default to the table owner, ... According to sql server ... If a user who creates a stored procedure does ...
    (microsoft.public.sqlserver.security)
  • Permissions for executing a stored procedure
    ... Truncate table permissions only default to table owner, ... So, eventhough, you have granted execute permissions to ... Instead using TRUNCATE TABLE, you could use DELETE FROM, ... >We have a stored procedure that has code in it to ...
    (microsoft.public.sqlserver.security)
  • Re: Logon failed for user ". but only for membership tables in same database that other request wor
    ... I was able to log on to computer b and execute the stored procedure. ... was no error after I corrected the permissions for the user. ... I can access the stored procedure but I can not use membership.validateuser. ... You may use the GRANT statement to grant the EXECUTE permission for a ...
    (microsoft.public.sqlserver.security)
  • Re: SET IDENTITY_INSERT Privileges?
    ... on the stored procedure to get around this. ... stored procedure and the user has execute permissions on the ... How do I grant permission to a SET Statement?? ...
    (microsoft.public.sqlserver.security)
  • Re: Exec permissions on Stored Procedure
    ... If I grant EXEC permissions on a Stored Procedure to a Domain User ... shouldn't they be able to Execute that stored procedure reguardless if they ...
    (microsoft.public.sqlserver.security)