Users and Truncate Table
From: Ben (ben_1_)
Date: 08/29/05
- Next message: jaylou: "Create table rights"
- Previous message: CR: "Re: Odd Rights Issue"
- Next in thread: Andrew J. Kelly: "Re: Users and Truncate Table"
- Reply: Andrew J. Kelly: "Re: Users and Truncate Table"
- Reply: Jose G. de Jesus Jr MCP, MCDBA: "RE: Users and Truncate Table"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Mon, 29 Aug 2005 13:47:39 -0700
How can i set up a use that is able to run a stored procedure that truncates
a specific table? I could swap the truncate for a drop table and create
table statement if that works better. The tables the user will be truncating
only contain summaries of the real data so i believe there isnt a worry of
security
thanks for the help!
ben
- Next message: jaylou: "Create table rights"
- Previous message: CR: "Re: Odd Rights Issue"
- Next in thread: Andrew J. Kelly: "Re: Users and Truncate Table"
- Reply: Andrew J. Kelly: "Re: Users and Truncate Table"
- Reply: Jose G. de Jesus Jr MCP, MCDBA: "RE: Users and Truncate Table"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]