Re: viewing existing aliases

From: Shri.DBA (tbalajiprabhu_at_hotmail.com)
Date: 08/29/05 

Date: Mon, 29 Aug 2005 22:37:10 +0530

Hi Guru,

sp_helpuser command will have you valid alias users in the database

Regards
Shri.DBA

"Bill Orova" <nospam@devdex.com> wrote in message
news:#O8fORKrFHA.3604@tk2msftngp13.phx.gbl...
>
> Hello Gurus,
> This one has me stumped. My boss loves to use aliases. One of the
> departments is getting an access violation error I tried to add on the
> preset user for them the message says there is already an alias
> existing. I tried to drop all aliases to then add them back hoping this
> would clear problem. the drop output said there were no aliases? My
> question is : Is there a way to view all aliases on a database or for a
> specific logon?
>
>
> *** Sent via Developersdex http://www.developersdex.com ***

Relevant Pages

  • Re: Help with Paradox 9 table schema
    ... And it makes perfect sense in the Paradoxian ... to the invoice database and see how much money I made! ... the linkage of tables for lookups you do not need to use aliases. ... MyDocuments and shares - but you really need to be able to define shares ...
    (comp.databases.paradox)
  • Re: Help with Paradox 9 table schema
    ... Jim Hargan wrote: ... self-contained child databases -- so everything I use is always aliased, ... If you change the working directory to the child database, when you do the linkage of tables for lookups you do not need to use aliases. ... you can move the database from one system to another provided that you can map the location to the same letter on the new system as on the old. ...
    (comp.databases.paradox)
  • dynamic mail alias lists?
    ... I use sendmail) map an alias to the run of a process that returns the ... in place of or in addition to aliases, but I still don't see a way to ... A database of users in different ... Please let me know if this is possible--or, for that matter, if I'm ...
    (freebsd-questions)
  • Re: Selecting back end(s) to use
    ... different database. ... > combined reporting application for a group of identically structured BE's. ... > What I would like to accomplish is that when user selects the BE's he/she ... > Does the FE application has to have aliases already setup for the BE ...
    (microsoft.public.access.modulesdaovba)
  • viewing existing aliases
    ... Hello Gurus, ... My boss loves to use aliases. ... departments is getting an access violation error I tried to add on the ...
    (microsoft.public.sqlserver.security)