Re: How to GRANT *all* permissions to *all* users?

Steve
Add the login to sysadmin server role

<steve.chambers@xxxxxxxxx> wrote in message
news:1170773941.309642.45560@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
In short, I would like to know how to do this i.e. give any user
permission to do anything (e.g. CREATE tables, ALTER tables etc.)

I'm asking because I recently converted from SQL Server 2000 to 2005
and initially the stored procedures couldn't be changed so had a quick
look on the web and found that applying the following 2 lines enabled
most things:

GRANT VIEW ANY DEFINITION TO public
GRANT VIEW SERVER STATE TO public

(http://www.microsoft.com/technet/technetmag/issues/2006/01/
ProtectMetaData/default.aspx)

But I still can't ALTER tables (this option is greyed out). I want to
give anyone working on the databases the ability to do anything (don't
worry, it's just a test environment, not the real thing).

Is there a GRANT or set of GRANT commands that I can apply to give
these permissions?

Thanks to anyone who can help/shed any light on this...

Cheers,
Steve



.

Relevant Pages

  • Re: Allowing Anonymous write access only.
    ... need at least READ permission for login. ... > been set up so that anonymous FTP users have write access only, this> may seem insecure and we do get a certain ammount of hackers or> taggers testing the system by dropping test files and folders onto the> server, but because anonymous users do not have read access they soon> find that they cannot download anything they upload and go elsewhere. ... This is where my problems have started,> I initialy replicated all the IIS setting and NTFS permission from my> NT box on my 2003 box but so far have been unable to achive the same> result, it appaers that I can only grant anonymous write access if I ...
    (microsoft.public.inetserver.iis.ftp)
  • Re: Complete Neophyte Question(s)
    ... You should not have to go Google to find out what WITH GRANT means. ... Server comes with online documentation on you hard disk. ... WITH GRANT is one of the more esotheric features in SQL Server in my ... Or does that depend on the permission? ...
    (microsoft.public.sqlserver.security)
  • Re: GRANT VIEW SERVER STATE to Database Role
    ... Since it is a Server permission, it has to be a login. ... If you have several domain logins to which you want to grant this permission, but you would like to limit how many times you grant this on the server, do the following. ...
    (microsoft.public.sqlserver.programming)
  • Re: Security Permission Issue with C# EXE on Intranet
    ... The default CAS permission grant for the intranet zone includes permission ... something in place for distributing CAS policy changes and, if not, your IT ... which is in the same directory as the C# .EXE on the server. ...
    (microsoft.public.dotnet.languages.csharp)
  • How to GRANT *all* permissions to *all* users?
    ... permission to do anything ... I'm asking because I recently converted from SQL Server 2000 to 2005 ... GRANT VIEW ANY DEFINITION TO public ... But I still can't ALTER tables. ...
    (microsoft.public.sqlserver.security)