() — Sybase SQL Server 4.0

  1                       Version 4.0 -- 1/15/89            sp_dropalias
  ______________________________________________________________________

  NAME:  sp_dropalias

  FUNCTION:
       Removes the alias user name identity that  had  been  established
       with sp_addalias.

  SYNTAX:
       sp_dropalias loginame

  EXAMPLES:
       sp_dropalias victoria








  sp_dropalias            Version 4.0 -- 1/15/89                       2
  ______________________________________________________________________
       Assuming that victoria had been  aliased  (for  example,  to  the
       Database  Owner)  in  the  current database, this statement drops
       victoria as an aliased user from the database.

  PARAMETERS:
       loginame -  is the name (in master.dbo.syslogins) of the user who
           was aliased to another user.

  COMMENTS:

       o Executing the sp_dropalias procedure deletes an alternate  suid
         mapping for a user from the sysalternates table.
       o When a user's alias is dropped, he or she may  no  longer  have
         access to the database for which the alias was created.

  MESSAGES:
       The user is no longer aliased to  another  user  in  the  current



  3                       Version 4.0 -- 1/15/89            sp_dropalias
  ______________________________________________________________________
           database.  He or she cannot use the database until the  Data-
           base   Owner  reinstates  him  or  her  using  sp_adduser  or
           sp_addalias.
       The named user doesn't have an alias in the current database.
       The loginame you supplied  has  no  account  on  SQL Server.   No
           action was taken.

  PERMISSIONS:
       Execute permission to Database Owner.

  TABLES USED:
       sysalternates

  SEE ALSO:
       sp_addalias,    sp_adduser,    sp_changedbowner,    sp_droplogin,
       sp_dropuser, sp_helpuser, USE
Museum
