Authorization Based on UserId and Parameter Data

Hi All,
I am novice for reporting services.
Is it possible to get the parameters of the report and do authorisation
check based on the parameter value and UserId ?
Or is there other alternative to this kind of requirement..
Thanks,
RaghuHi,
It is possible but not advisable, there is no field mask for the password
field. Best bet is to use custom form for the password authentication.
Amarnath
"RAV" wrote:
> Hi All,
> I am novice for reporting services.
> Is it possible to get the parameters of the report and do authorisation
> check based on the parameter value and UserId ?
> Or is there other alternative to this kind of requirement..
> Thanks,
> Raghu
>

Authenticating from Active Directory Domain

We use a query that gets the suser_name parameter and
inserts it into a table.
A user converted to an Active Directory Domain and the
suser_name comes up as null.
Is this the way it works? Or is there some setting that
has to be changed?
Any help appreciated.
Thanks,
GeorgeDirectly from BOL
suser_name is obsolete and always returns NULL in S2K.
"George Galcik" <anonymous@.discussions.microsoft.com> wrote in message
news:005b01c3dab4$6bf0fdb0$a101280a@.phx.gbl...

quote:

---

> We use a query that gets the suser_name parameter and
> inserts it into a table.
> A user converted to an Active Directory Domain and the
> suser_name comes up as null.
> Is this the way it works? Or is there some setting that
> has to be changed?
> Any help appreciated.
> Thanks,
> George
>

---

|||Thanks for your help, Scott.
George

quote:

---

>--Original Message--
>Directly from BOL
>suser_name is obsolete and always returns NULL in S2K.
>"George Galcik" <anonymous@.discussions.microsoft.com>

---

wrote in message

quote:

---

>news:005b01c3dab4$6bf0fdb0$a101280a@.phx.gbl...
>
>.
>

---

Attachments with database mail

HEllo,
is it posible to have, the attachments of mail as body.
It is possible with xp_smtp_sendmail(@.messagefile parameter).
I don't find the same with sp_send_dbmail
Thank you.
Ad@.attach_query_result_as_file ?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
<aurelien.decamps@.gmail.com> wrote in message
news:7678d5c5-915f-40d4-9acc-821515821334@.k37g2000hsf.googlegroups.com...
> HEllo,
> is it posible to have, the attachments of mail as body.
> It is possible with xp_smtp_sendmail(@.messagefile parameter).
> I don't find the same with sp_send_dbmail
>
> Thank you.
> Ad|||Wasn't clear, but I *think* the op wanted an HTML file to be implanted as
the body.
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:1CEEF022-D482-4D4D-86E5-5344E33B32C6@.microsoft.com...
> @.attach_query_result_as_file ?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> <aurelien.decamps@.gmail.com> wrote in message
> news:7678d5c5-915f-40d4-9acc-821515821334@.k37g2000hsf.googlegroups.com...
>> HEllo,
>> is it posible to have, the attachments of mail as body.
>> It is possible with xp_smtp_sendmail(@.messagefile parameter).
>> I don't find the same with sp_send_dbmail
>>
>> Thank you.
>> Ad
>|||Ah, OK, I didn't get that... Hmm, I can't see a way to attach a file and make it the body of the
e-mail. I haven't tried various permutations of params to do just that, though...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:eXJILMXqIHA.4112@.TK2MSFTNGP03.phx.gbl...
> Wasn't clear, but I *think* the op wanted an HTML file to be implanted as the body.
>
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:1CEEF022-D482-4D4D-86E5-5344E33B32C6@.microsoft.com...
>> @.attach_query_result_as_file ?
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>> <aurelien.decamps@.gmail.com> wrote in message
>> news:7678d5c5-915f-40d4-9acc-821515821334@.k37g2000hsf.googlegroups.com...
>> HEllo,
>> is it posible to have, the attachments of mail as body.
>> It is possible with xp_smtp_sendmail(@.messagefile parameter).
>> I don't find the same with sp_send_dbmail
>>
>> Thank you.
>> Ad
>|||Hi
http://sqlblogcasts.com/blogs/tonyrogerson/archive/2008/03/28/send-table-or-view-as-embedded-html-lt-table-gt-in-an-email-stored-procedure.aspx
<aurelien.decamps@.gmail.com> wrote in message
news:7678d5c5-915f-40d4-9acc-821515821334@.k37g2000hsf.googlegroups.com...
> HEllo,
> is it posible to have, the attachments of mail as body.
> It is possible with xp_smtp_sendmail(@.messagefile parameter).
> I don't find the same with sp_send_dbmail
>
> Thank you.
> Ad|||Hello, thank you for your answer, but it's true that the problem is
not clear :).
I want to have the contents of a text file in the body of the email.
like @.messagefile parameter of the xp_smtp_sendmail proc
On 29 avr, 09:42, "Uri Dimant" <u...@.iscar.co.il> wrote:
> Hihttp://sqlblogcasts.com/blogs/tonyrogerson/archive/2008/03/28/send-ta...=
> <aurelien.deca...@.gmail.com> wrote in message
> news:7678d5c5-915f-40d4-9acc-821515821334@.k37g2000hsf.googlegroups.com...
>
> > HEllo,
> > is it posible to have, the attachments of mail as body.
> > It is possible with xp_smtp_sendmail(@.messagefile parameter).
> > I don't find the same with sp_send_dbmail
> > Thank you.
> > Ad- Masquer le texte des messages pr=E9c=E9dents -
> - Afficher le texte des messages pr=E9c=E9dents -