Grant permission to table for truncate table

hi,
we have object-level user security. That user need permission for truncate
one table. I can't set the user as sysadmin or DBO.
any way that I could grant the user to have truncate that table?
Thanks
If you are on 2005, you can grant CONTROL permissions.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"mecn" <mecn2002@.yahoo.com> wrote in message news:%23HWk1zE1HHA.1336@.TK2MSFTNGP04.phx.gbl...
> hi,
> we have object-level user security. That user need permission for truncate
> one table. I can't set the user as sysadmin or DBO.
> any way that I could grant the user to have truncate that table?
> Thanks
>

Grant permission to table for truncate table

hi,
we have object-level user security. That user need permission for truncate
one table. I can't set the user as sysadmin or DBO.
any way that I could grant the user to have truncate that table?
ThanksDELETE ?
"mecn" <mecn2002@.yahoo.com> wrote in message
news:%23HWk1zE1HHA.1336@.TK2MSFTNGP04.phx.gbl...
> hi,
> we have object-level user security. That user need permission for truncate
> one table. I can't set the user as sysadmin or DBO.
> any way that I could grant the user to have truncate that table?
> Thanks
>|||For some reason we could NOT use delete.
1. Identity id reset.
2. large table
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ODT5w1E1HHA.1100@.TK2MSFTNGP06.phx.gbl...
> DELETE ?
>
> "mecn" <mecn2002@.yahoo.com> wrote in message
> news:%23HWk1zE1HHA.1336@.TK2MSFTNGP04.phx.gbl...
>|||"EXECUTE AS" ?
http://msdn2.microsoft.com/en-us/library/ms188354.aspx
"mecn" wrote:

> For some reason we could NOT use delete.
> 1. Identity id reset.
> 2. large table
>
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:ODT5w1E1HHA.1100@.TK2MSFTNGP06.phx.gbl...
>
>|||On Aug 2, 8:52 am, Pranil <Pra...@.discussions.microsoft.com> wrote:
> "EXECUTE AS" ?
> http://msdn2.microsoft.com/en-us/library/ms188354.aspx
>
> "mecn" wrote:
>
>
>
> - Show quoted text -
You need to have alter permission on the table to get the truncate
permission.
Thanks
Shiju Samuel|||If you are on 2005, you can grant CONTROL permissions.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"mecn" <mecn2002@.yahoo.com> wrote in message news:%23HWk1zE1HHA.1336@.TK2MSFTNGP04.phx.gbl...

> hi,
> we have object-level user security. That user need permission for truncate
> one table. I can't set the user as sysadmin or DBO.
> any way that I could grant the user to have truncate that table?
> Thanks
>

Grant permission to table for truncate table

hi,
we have object-level user security. That user need permission for truncate
one table. I can't set the user as sysadmin or DBO.
any way that I could grant the user to have truncate that table?
ThanksDELETE ?
"mecn" <mecn2002@.yahoo.com> wrote in message
news:%23HWk1zE1HHA.1336@.TK2MSFTNGP04.phx.gbl...
> hi,
> we have object-level user security. That user need permission for truncate
> one table. I can't set the user as sysadmin or DBO.
> any way that I could grant the user to have truncate that table?
> Thanks
>|||For some reason we could NOT use delete.
1. Identity id reset.
2. large table
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ODT5w1E1HHA.1100@.TK2MSFTNGP06.phx.gbl...
> DELETE ?
>
> "mecn" <mecn2002@.yahoo.com> wrote in message
> news:%23HWk1zE1HHA.1336@.TK2MSFTNGP04.phx.gbl...
>> hi,
>> we have object-level user security. That user need permission for
>> truncate one table. I can't set the user as sysadmin or DBO.
>> any way that I could grant the user to have truncate that table?
>> Thanks
>|||"EXECUTE AS" ?
http://msdn2.microsoft.com/en-us/library/ms188354.aspx
"mecn" wrote:
> For some reason we could NOT use delete.
> 1. Identity id reset.
> 2. large table
>
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:ODT5w1E1HHA.1100@.TK2MSFTNGP06.phx.gbl...
> > DELETE ?
> >
> >
> >
> > "mecn" <mecn2002@.yahoo.com> wrote in message
> > news:%23HWk1zE1HHA.1336@.TK2MSFTNGP04.phx.gbl...
> >> hi,
> >> we have object-level user security. That user need permission for
> >> truncate one table. I can't set the user as sysadmin or DBO.
> >> any way that I could grant the user to have truncate that table?
> >>
> >> Thanks
> >>
> >
> >
>
>|||On Aug 2, 8:52 am, Pranil <Pra...@.discussions.microsoft.com> wrote:
> "EXECUTE AS" ?
> http://msdn2.microsoft.com/en-us/library/ms188354.aspx
>
> "mecn" wrote:
> > For some reason we could NOT use delete.
> > 1. Identity id reset.
> > 2. large table
> > "Uri Dimant" <u...@.iscar.co.il> wrote in message
> >news:ODT5w1E1HHA.1100@.TK2MSFTNGP06.phx.gbl...
> > > DELETE ?
> > > "mecn" <mecn2...@.yahoo.com> wrote in message
> > >news:%23HWk1zE1HHA.1336@.TK2MSFTNGP04.phx.gbl...
> > >> hi,
> > >> we have object-level user security. That user need permission for
> > >> truncate one table. I can't set the user as sysadmin or DBO.
> > >> any way that I could grant the user to have truncate that table?
> > >> Thanks- Hide quoted text -
> - Show quoted text -
You need to have alter permission on the table to get the truncate
permission.
Thanks
Shiju Samuel|||If you are on 2005, you can grant CONTROL permissions.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"mecn" <mecn2002@.yahoo.com> wrote in message news:%23HWk1zE1HHA.1336@.TK2MSFTNGP04.phx.gbl...
> hi,
> we have object-level user security. That user need permission for truncate
> one table. I can't set the user as sysadmin or DBO.
> any way that I could grant the user to have truncate that table?
> Thanks
>sql

Good SysAdmin Responsibilities

Hi

I'm one in an IT department of 3, and while my primary role is application development, I'm also the DBA by default. I know enough to make everything work and troubleshoot problems, etc.

We do alot of everything: Replication, Linked Servers, and soon we'll be starting clustering.

What I'm wondering is what kind of actions should I be doing on a regular basis to maintain and ensure that all my db's (my babies) are healthy and running optimally. DBCC commands, watching my indexes, statistics, etc.

I know this is a large question, so pointing me to certain books, whitepapers, websites, etc is totally fine.

Any help would be appreciated!

KPWow...where to start...

Do you know what your recovery model is?

I would make sure that you set up maint plans (1 for systems dbs, 1 per every other database) immediatley...that's the easiest way...

I write procedures to perform these tasks though...there are more options available...|||Right now I'm using a Simple Recovery method.

Right now DB's really aren't backed up regularly, I run them from time to time. That's my main focus now - getting my database backups scheduled and my recovery model nailed down.

I've setup DB Maintainence Plans, the App Dev guy in me though likes to know specifically what's being done.

Would setting up one DB Maint Plan that just Reorgs Data, Removes Space and Test Integrity for all my DB's that's run once a week be ok? Or do I really need one for each DB? I would handle backups differently.

Thanks!