Re: creating logins in stored procedure (yukon)

From: implacabile (implacabile_at_usa.net)
Date: 06/15/05 

Date: Wed, 15 Jun 2005 20:34:53 +0200

> exec sp_configure 'allow updates', '1'
>

yes, I've tried that, then I've copied the src of sp_addlogin,
and tried it with a normal user, but it doesn't work: in sql server
2005 the sp creates dinamically a varchar with 'create login .....' and
then it exec it, so it doesn't manipulate directly the tables, so the
users need additional permissions (because of the exec).
I think I'll have to make the users members of securityadmin
role, or some other.

Relevant Pages

  • Re: No more indexing on text
    ... Looking for a SQL Server replication book? ... DROP FULLTEXT CATALOG CmpArchivorCat ... exec sp_fulltext_catalog 'CmpArchivorCat', 'create' ... both text/plain and text/html in my file type column. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Running a DTS Job from a stored procedure
    ... We are running SQL Server 2000. ... -- Create a Pkg Object ... EXEC sp_DisplayOAErrorInfo @oPKG, @hr ...
    (microsoft.public.sqlserver.dts)
  • Re: Auto truncate a string to be inserted to SQL table
    ... EXEC p --Warning was not returned ... Tibor Karaszi, SQL Server MVP ... >> Tibor Karaszi, SQL Server MVP ... >>> message is given...i might need to just truncate the string without halting>>> the process... ...
    (microsoft.public.sqlserver.programming)
  • Re: Error 21776: After creating new login
    ... EXEC DATA0003.dbo.sp_addlogin 'test','pwd' ... > another SQL Server session is not visible to the SQL-DMO session. ... > Jasper Smith ... >> Users collection. ...
    (microsoft.public.sqlserver.security)
  • Re: Permissions!
    ... be aware that 'dbo' is a special user that has full permissions. ... Database permissions are not checked for the 'dbo' user so it serves no ... You will need individual logins/users so that SQL Server can identify users ... EXEC sp_addrole 'Role1' ...
    (microsoft.public.sqlserver.security)