Re: SQL 2000 security role

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



Add the user to the db_Datawriter role, this is a built in role which
should fit your needs:

db_datawriter (from the bol)

"Members of the db_datawriter fixed database role can add, delete, or
change data in all user tables. "

HTH, jens Suessmeyer.

.



Relevant Pages

  • Re: changeobjectowner permission
    ... The BOL says the following: Only members of sysadmin fixed server role, ...
    (microsoft.public.sqlserver.server)
  • Re: Excuse Me...
    ... I once felt intimidated by people who obviously knew each other and met in RL, and had a much closer relationship than simply posters to a common group. ... There are some ferocious researchers on this group, if you just repeat opinions with no backup, you'll only look silly. ... you should consider some of your advertised decades old members maybe ... But he modified his debating style to fit in better, and eventually even won some people over to his point of view. ...
    (rec.arts.mystery)
  • Re: Excuse Me...
    ... I'm not sure we want to attract "new members" as such. ... group, if you just repeat opinions with no backup, you'll only look silly. ... Those who post persistently, and with enjoyment, are those who BEST FIT ... If you think RAM is "prickly" I invite you to explore some of the other ...
    (rec.arts.mystery)
  • Re: Todays XFORCE?
    ... He's also among the lesser-known members of any ... up of hardcore killers...I also think Elixir isn't such a bad fit ... As for Rahne, ... hardcore killers. ...
    (rec.arts.comics.marvel.universe)
  • Re: Watson, and black IQ
    ... Are you suggesting we should assume all members of a ... particular genetic ancestry will fit all statistically identified ... tendencies. ...
    (rec.martial-arts)