Showing posts with label databaseis. Show all posts
Showing posts with label databaseis. Show all posts

Friday, March 30, 2012

putting image on Crystal Report

Is there any Facility in Crystal Report 9 to Insert image on Crystal report Dynamically... from Database?
Is there any image/Picture control available
please reply me regarding thisHi!
Followinng is how to load picture in Cr from some path dynamically.

for that you will have to do thid

1. Include Crystal Report Designer in to VB
2. add a picture to Detail section of Report
3. double click Detail seciton and code this

Set Picture1.FormattedPicture = LoadPicture(Filepath)

i have used it with Cr8.5.

Monday, February 20, 2012

Public permissions

Why is the Public group granted permission to the systables in my database?
Is it safe to remove the select permission from all the sys tables?"Mike" <annon@.hotmail.com> wrote in message
news:OzWZVzbGFHA.2412@.TK2MSFTNGP14.phx.gbl...
> Why is the Public group granted permission to the systables in my
database?
> Is it safe to remove the select permission from all the sys tables?
>
Think of "public" as the "everyone" group in NT. It allows the basic,
minimum permissions to the database. Read the following for a better
understanding:
http://www.microsoft.com/technet/pr...s/c05ppcsq.mspx
You can remove the select permission from public, be aware that this may
cause other issues with stored procedures, etc.
Steve|||SQL Server uses the system tables internally for some
functions and that's why public has permissions on these
tables. There are functions such as resolving names using
internal ids stored in the system tables. And what
permissions are needed on which tables gets further
complicated by what data access mechanisms are used by what
drivers or providers using what applications or tools. Can
you remove them across the board and not have any problems?
Across the board...no. And it's no simple task to go through
and figure or what can and can't be changed.
-Sue
On Wed, 23 Feb 2005 10:30:33 -0500, "Mike"
<annon@.hotmail.com> wrote:

>Why is the Public group granted permission to the systables in my database?
>Is it safe to remove the select permission from all the sys tables?
>