Re: Transact: GRANT LOGIN

Tech-Archive recommends: Speed Up your PC by fixing your registry

On Sun, 19 Jul 2009 19:00:00 -0700, Linchi Shea
If you are
CREATE LOGIN, continue to use it and you don't need to use sp_grantlogin.

Thanks Linchi,

I tested and indeed I can login to SQL with the newly created login
name.

But as antecipated, I still need to grant access to individual
databases and give rights to SELECT, UPDATE, etc.

After successfully creating a "newUser' login, I tried:

Grant SELECT, UPDATE to newUser

....Sql Server responds:

Cannot find the user 'newUser', because it does not exist or you do
not have permission.

However, the account I am using for those experiments has sysadmin,
setupadmin serveradmin and securityadmin rights.

If I issue a "USE testDB" command just before this GRANT command
in an attempt to give the above rights to a specific database, I get
the same error message.

Please bear with me, this is all very new to me and I'm not having too
much luck trying to find working examples.

Thanks for your input so far, and for any moree thoughts.
Bruno.
.

Relevant Pages

  • Re: Complete Neophyte Question(s)
    ... No you cannot remove a login from the 'public' role. ... For rights to _use_ objects then the appropriate rights need to be granted ... GRANT SELECT ON dbo.Orders TO OrderViewers ... for a database that is supposed to be secured it is a bad idea ...
    (microsoft.public.sqlserver.security)
  • Re: Removing Permissions from the public role
    ... did you think about putting those 8 tables in a different schema, and then just granting rights to that schema, revoking the rights for that group from public. ... that user and ran some grant scripts to allow them to select from the 8 ... I see that there is a public role ... the public security role is still allowing the new login access to all ...
    (microsoft.public.sqlserver.setup)
  • Re: No db access after publishing web site
    ... GRANT UPDATE TO ... If I detach and attach this database on a different PC (according that PC ... Cannot open database "pago" requested by the login. ... Are you detaching/attaching the SQL Server Express database correctly ...
    (microsoft.public.dotnet.framework.aspnet)
  • 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: Removing Permissions from the public role
    ... that user and ran some grant scripts to allow them to select from the 8 ... I see that there is a public role ... the public security role is still allowing the new login access to all ... GRANT SELECT ON PDF TO briank ...
    (microsoft.public.sqlserver.setup)