Re: Get user syntax



Ryan,

Depending on whether you want a User or a Login, you can try one of the
following: CURRENT_USER, SYSTEM_USER, USER_NAME, SUSER_SNAME. Check them
out in the Books Online, or just run them and choose what you prefer to use.

RLF

"Ryan Mcbee" <RyanMcbee@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:266EBEEE-3FB5-448D-A58B-0EF6D8F006F1@xxxxxxxxxxxxxxxx
I am building a view for a report and one of the requirements is to grab
the
user who is running the report. What would this syntax look like? I
thought
it was getuser(), but no luck there.

Thanks,

Ryan


.



Relevant Pages

  • 2 Login pages in web.config = ERROR!
    ... Login pages depending on the original page they are trying to access. ... in IIS. ... occur if I comment out the <authentication> element that is located within ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: change users login for dbo user
    ... You'd want to change the database owner using ... procedure in books online. ... >dbo instead of a SQL server login. ... >but it indicates this sp cannot be used for dbo user. ...
    (microsoft.public.sqlserver.security)
  • Making a secured webs site for downloading updates
    ... I have many products and I would like the followings: ... - the user connect on my web site with a login and Password ... Depending of this password the user have access of the product he has ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: restricting users during certain times/days
    ... if you only want a user to be able to login during the ... Depending on how universal I wanted the restriction, ... IT Consultant, Enterprise Technology Solutions ... Toronto Dominion Bank Financial Group ...
    (comp.os.linux.misc)
  • Re: How can i alter info to send visiters to a different page depe
    ... In this box i have required them to insert their personal PON ... > | number in order to login to their personal team screen. ...
    (microsoft.public.frontpage.client)