> Hi all!
>
> I have a problem with a database with more than 100 tables. I have theese
> tables in MSDE and linked to an Access database. If I open this database,
> it
> tells me that I have no SELECT permission for every table, so I would like
> to
> have a way to grant all permissions (SELECT, DELETE, INSERT, CRETATE TABLE
> ,
> and so on) to every table in my database in a single sentence.
>
> I have been doing it table by table, but I am sure there must be a way to
> grant ALL theese permissions to ALL the tables in a database at a time.
>
> Any help will be very appreciated!
>
> Thank you,
>
> --
> Xavier Boneu

> Jens,
>
> I am looking for DB_roles in T-SQL but can't find it. Do you know where
> should I find it?
>
> Thanks for your help.
>
> Xavier Boneu
>
>
> "Jens Süßmeyer" wrote:
>
>> Did you already had a look on BOL for the predefined DB_roles like
>> db_datareader, db_datawriter and db_ddladmin. I think that´ll help you
>> further.
>>
>> HTH, Jens Suessmeyer.
>>
>> ---
>> http://www.sqlserver2005.de
>> ---
>>
>>
>> "Xavier Boneu" <XavierBoneu@discussions.microsoft.com> schrieb im
>> Newsbeitrag news:E93CF993-D796-4FE3-850B-FEC4EAE63DE4@microsoft.com...
>> > Hi all!
>> >
>> > I have a problem with a database with more than 100 tables. I have
>> > theese
>> > tables in MSDE and linked to an Access database. If I open this
>> > database,
>> > it
>> > tells me that I have no SELECT permission for every table, so I would
>> > like
>> > to
>> > have a way to grant all permissions (SELECT, DELETE, INSERT, CRETATE
>> > TABLE
>> > ,
>> > and so on) to every table in my database in a single sentence.
>> >
>> > I have been doing it table by table, but I am sure there must be a way
>> > to
>> > grant ALL theese permissions to ALL the tables in a database at a time.
>> >
>> > Any help will be very appreciated!
>> >
>> > Thank you,
>> >
>> > --
>> > Xavier Boneu
>>
>>
>>

> Great! It works!
>
> I'll grant db_datawritter and db_datareader to all the users. I'll have to
> type the sentences for every user, but at least, I don't have to type it
> for
> every one of the 101 tables!
>
> Thanks!!
>
> --
> Xavier Boneu
>
>
> "Jens Süßmeyer" wrote:
>
>> Just look for a word like "db_datawriter". Or just take a look here:
>>
>> http://www.siebelonmicrosoft.com/mssiebel/Downloads/Application_Replatforming/SiebelDBMig/SQLServer2000SecurityWhitepaper.doc
>>
>>
>>
>> HTH, Jens Suessmeyer.
>>
>> ---
>> http://www.sqlserver2005.de
>> ---
>> "Xavier Boneu" <XavierBoneu@discussions.microsoft.com> schrieb im
>> Newsbeitrag news:E046767F-FECD-44B4-A632-B39E09A499AA@microsoft.com...
>> > Jens,
>> >
>> > I am looking for DB_roles in T-SQL but can't find it. Do you know where
>> > should I find it?
>> >
>> > Thanks for your help.
>> >
>> > Xavier Boneu
>> >
>> >
>> > "Jens Süßmeyer" wrote:
>> >
>> >> Did you already had a look on BOL for the predefined DB_roles like
>> >> db_datareader, db_datawriter and db_ddladmin. I think that´ll help you
>> >> further.
>> >>
>> >> HTH, Jens Suessmeyer.
>> >>
>> >> ---
>> >> http://www.sqlserver2005.de
>> >> ---
>> >>
>> >>
>> >> "Xavier Boneu" <XavierBoneu@discussions.microsoft.com> schrieb im
>> >> Newsbeitrag news:E93CF993-D796-4FE3-850B-FEC4EAE63DE4@microsoft.com...
>> >> > Hi all!
>> >> >
>> >> > I have a problem with a database with more than 100 tables. I have
>> >> > theese
>> >> > tables in MSDE and linked to an Access database. If I open this
>> >> > database,
>> >> > it
>> >> > tells me that I have no SELECT permission for every table, so I
>> >> > would
>> >> > like
>> >> > to
>> >> > have a way to grant all permissions (SELECT, DELETE, INSERT, CRETATE
>> >> > TABLE
>> >> > ,
>> >> > and so on) to every table in my database in a single sentence.
>> >> >
>> >> > I have been doing it table by table, but I am sure there must be a
>> >> > way
>> >> > to
>> >> > grant ALL theese permissions to ALL the tables in a database at a
>> >> > time.
>> >> >
>> >> > Any help will be very appreciated!
>> >> >
>> >> > Thank you,
>> >> >
>> >> > --
>> >> > Xavier Boneu
>> >>
>> >>
>> >>
>>
>>
>>