Password management and Crystal Reports problem.

We've run into a problem with passwords in GP 7.0. We're trying to use
Crystal Reports to do custom reporting, and the user should be able to use
their GP login/password in Crystal. However apparently GP will encrypt or
otherwise obfuscate the users password if the user is setup through GP. This
then prevents the user from using their GP login/password as their actual
password is different than what they set it to.

If I manually set their password using Enterprise Manager then they can use
the same login/password for both GP and Crystal, but they are no longer able
to change their password from within GP.

What is the recommendation for using Crystal with GP? The product manuals
make no mention of this problem or have any recommendation for user
management when using Crystal. I shouldn't have to administer 2 logins for
each user, and the users won't like having to remember 2 login/passwords to
be able to do their jobs.

Mike Kruchten


0
mkruchten (21)
7/13/2004 7:44:07 PM
greatplains 29623 articles. 3 followers. Follow

2 Replies
770 Views

Similar Articles

[PageSpeed] 9

What I do is create a sql login specifically for report.  
I then modify the permissions of this sql login to be 
read-only (ie deny datawriter). You can then apply 
permissions to specific tables or views to this user.  

The Great Plains User IDs are assigned to the DYNGRP role 
within SQL, so be very careful when unencrypting those 
passwords.  The user could then use their User ID and 
password to delete data etc. using Enterprise Manager or 
Access etc.  Keep the user IDs encrypted so that they can 
only access the data within Great Plains.  Then create a 
separate sql login that you can control data access to 
for external applications.

>-----Original Message-----
>We've run into a problem with passwords in GP 7.0. We're 
trying to use
>Crystal Reports to do custom reporting, and the user 
should be able to use
>their GP login/password in Crystal. However apparently 
GP will encrypt or
>otherwise obfuscate the users password if the user is 
setup through GP. This
>then prevents the user from using their GP 
login/password as their actual
>password is different than what they set it to.
>
>If I manually set their password using Enterprise 
Manager then they can use
>the same login/password for both GP and Crystal, but 
they are no longer able
>to change their password from within GP.
>
>What is the recommendation for using Crystal with GP? 
The product manuals
>make no mention of this problem or have any 
recommendation for user
>management when using Crystal. I shouldn't have to 
administer 2 logins for
>each user, and the users won't like having to remember 2 
login/passwords to
>be able to do their jobs.
>
>Mike Kruchten
>
>
>.
>
0
anonymous (74717)
7/14/2004 4:41:17 PM
Hi There,

We normally create users on the SQL server using their windows logins. This
also streamlines the report so that the user doesn't have to login to the
datasource in crystal all the time.  You can modify the grant70.sql script
found in the SQL-Util folder on the server install to create a new role
called REPORTS or whatever, and grant that role only SELECT access to the
databases.


EXEC sp_addrole 'REPORTS'

declare @cStatement varchar(255)

declare G_cursor CURSOR for select 'grant select on [' +
convert(varchar(64),name) + '] to REPORTS' from sysobjects
 where (type = 'U' or type = 'V') and uid = 1

set nocount on
OPEN G_cursor
FETCH NEXT FROM G_cursor INTO @cStatement
WHILE (@@FETCH_STATUS <> -1)
begin
 EXEC (@cStatement)
 FETCH NEXT FROM G_cursor INTO @cStatement
end
DEALLOCATE G_cursor



Fabian


"Mike Kruchten" <mkruchten@fsisolutions.com> wrote in message
news:%23jVYJHRaEHA.3756@tk2msftngp13.phx.gbl...
> We've run into a problem with passwords in GP 7.0. We're trying to use
> Crystal Reports to do custom reporting, and the user should be able to use
> their GP login/password in Crystal. However apparently GP will encrypt or
> otherwise obfuscate the users password if the user is setup through GP.
This
> then prevents the user from using their GP login/password as their actual
> password is different than what they set it to.
>
> If I manually set their password using Enterprise Manager then they can
use
> the same login/password for both GP and Crystal, but they are no longer
able
> to change their password from within GP.
>
> What is the recommendation for using Crystal with GP? The product manuals
> make no mention of this problem or have any recommendation for user
> management when using Crystal. I shouldn't have to administer 2 logins for
> each user, and the users won't like having to remember 2 login/passwords
to
> be able to do their jobs.
>
> Mike Kruchten
>
>


0
fabian1 (2)
7/14/2004 5:58:13 PM
Reply:

Similar Artilces:

SBS firewall from Server Management
Recently I had someone trying to get into my SBS 2003 server so over the weekend I went into Server Management and under Internet and email chose enable firewall and all was fine. But for some reason it was not letting the company phones get their email forwarded over. I turned off the firewall, and since then I have not been able to get into my server via domain/remote or domain/exchange. Any help would be greatly appreciated. You actually haven't given us much information. Here would be my questions, and this is by no means complete: 1) Is your SBS a single-NIC or dual...

Report Filter
I want to filter out null entries from a field in my report and am getting errors on my expressions My Report is Sourced from a Table called "Table1", the field is "Field1" that I want to filter out null entries. * To filer out null entries from this field in the report shouldn't it be simply enterring: [Table1].[Field1] is not null (in the Properties/Data/Filter Tab" Yes (in the Properties/Data/Filter Tab") Can someone please assist. Stew wrote: >I want to filter out null entries from a field in my report and am >getting errors on my express...

Password Protect Two Sub-contact Lists
Hi everyone! I have a regular contact list, and within this list I have two subcontact lists. One is personal, and the other is personal business. How can I password protect the personal and personal business lists? Thanks for any help! Sorry, I just realized that there's a newsgroup dedicated to contacts. I'll post this there. Thanks! Nick2112@sympatico.ca wrote: > Hi everyone! > > I have a regular contact list, and within this list I have two > subcontact lists. One is personal, and the other is personal business. > How can I password protect the personal and...

Passwords #5
I would like to password protect a workbook so that when the workbook is selected to open a dialog box pops up asking for the password and after the password is entered correctly the workbook will then open. Thanks for the the help. Todd Todd, do a save as and look under options, depending on what version you are using and set a password to open -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 97 & 2000 ** remove news from my email address t...

Problem receiving mails using VPN
Hi. I have a problem updating my folders in Outlook 2003 when I'm using th VPN at home to connect to the Exchange server. I can however send email with no problem. Outlook states that I'm connected. When it tries to update the folde showing the status "Waiting to update this folder" the Outlook icon i the system tray tells me that "Outlook is requesting data from th server" but nothing happens. I can ping the IP address (and server name) of the Exchange server. When I create a new message and try to look up the recepient from th addressbook outlook freezes. So...

Passwords
Hi, I have a password field in a database. How do I set it so that a user can only type in 7 characters for a password. and if they type more an error message will appear? Please hi, Daz01 wrote: > Hi, I have a password field in a database. How do I set it so that a > user can only type in 7 characters for a password. and if they type > more an error message will appear? You may use the ValidationRule and ValidationText of the field in the table design view. Setting ValidationRule to Len([YourField])>7) will raise an error in your case. mfG --> stefan <-- ...

add older HP 500"all in one" HP printer, fax, copier problem
I am not able to install a "all in one" HP printer, copier, fax, and scanner to my PC. I have Microsoft XP professional. As I attempt to follow the install/add on hardware directions i, in the last step, get a message of, "sorry, we have encountered a problem and are unable to complete the install" message. There is nothing wrong with the printer and I know it works as I had it working before on the computer but after having installed XP pro I left it disconnected for a long while and now am not able to get it installed. Help me somebody by giving me instr...

System Stability Report Won't Render
Hi All, Running Vista HB SP2. Performance Monitor and Reliability Monitor are running and generating data. When I click on an event in Reliability Monitor I get a pop-up message with a red X. Internet Explorer cannot download . (there is a space before the period) The system cannot find the file specified. Any idea what file it's looking for? We have pinpointed the problem. You are using the most buggy OS ever made in human history. GIVE THE DARN THING UP AND UPRGRADE TO WIN7 or MACOSX "Gary" <gary@extension.invalid> wrote in message ne...

Add day of week to data from external report (html)
I have a spreadsheet which lists a date and time as 1/02/2007 8:31:36 AM. I would like to be able to add the day of the week for the date in column A. It would be preferred to have the day appear directly in the column but would be acceptable to add a column for it. -- Gerry St As long as you have that date and time in a cell as an Excel datetime then it is simply a matter of formatting in Excel, Format (menu), cells, custom ddd mm/dd/yyyy hh:mm -- --- HTH, David McRitchie, Microsoft MVP - Excel My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: ...

How to disable context menu options in disk management
Hi, can anybody tell me how to disable the format and change drive letter options from the context menu which pop up when the user click on one particular partition in the disk management option of Computer management. Thanks. ...

Integration Manager V10 SP4 SOP
I have created an integration for SOP entries and get a error advising that there is no Qty Override password. However I can not see where to enter the password in v10. It was there previously in V8. Can anyone advise where this is loacted. Thanks Hi Alpet, In GP 10, the password field for Override Quantity Shortages can be maintained in Sales Order Processing Setup Options window (Microsoft Dynamics GP>>Tools>>Setup>>Sales>>Sales Order Processing, Options TAB). In Integration Manager, all passwords can be maintained in the Options TAB in the Integr...

problem with saving #2
Hello everybody, I hope somebody can help with the following problem. This is th situation: I have a java application which basically writes data (integers an strings) to an excel spreadsheet. The spreadsheet is doing th necessary calculations and reads back the results to the jav application. At least he is supposed to do so. But (as you probably guessed) it doesn't. Although in windows explore I can see he has changed the excel-file and when I open the file I ca see the correct data he reads back older data. More precisely the dat that has been saved when I manually open and close the...

Recipients problem in received mails
Hi, We're using Exchange 2003+SP2 in mixed mode with Exchange 5.5 SP4. Most of the user mailboxes already moved to new Exchange server. Since the move some of the people started getting mails that do not have in To: field the real recipient name but another user name from the organization. We started thinking how come the user gets another user's mail because there was only one recipient name in the "To:" field. When I checked the Exchange server, I saw in Message Tracking Center the message that came to that user was actually intended for couple of users but the Outlo...

Sending reports to via email
Is it possible to create a workflow that sends an email with a report to management with all opportunities where the closing date is in the past...? MS CRM using Reporting Services (SSRS) and SSRS have this functionality build-in. How to configure SSRS: http://msdn2.microsoft.com/en-us/library/ms345234.aspx Regards. pflis ...

Passing values between reports
Here is the deal, I have a billing system that uses multiple reports. All reports get open when I run the system. Everything works fine when there is data in all the reports, and data summaries gets passed from all reports to the summary report. Sometimes in one or more reports in a certain month, there is no data, and instead of passing 0 (zero) from the these reports that do not have data to the summary reports. I get #Error or #Name. (The summary values to be passed are usually in the footer section of the reports) I use this on the summary report to get the values from the re...

Keep user passwords
Hi! We've just finished installing a new Exchange server and connecting it to a separate DC. We used to have everything on the same server but we'd like to be able to scale our solution better in the future - therefore the new setup. Users are primarily connecting to Exchange by means of RPC over HTTP from clients that are not part of our AD. The old setup allowed users to save passwords if they configured their clients to use NTLM authentication and followed the directions in this article: http://support.microsoft.com/default.aspx?scid=kb;en-us;820281. This worked both for RPC...

integrity problems while copying
I work with a data base with visual basic. when i copy the file on my lokal disk and then do any changes, after another opening the excel is not able to open the file and after reperation all pivot table are not active any more. i will be gratefull to get some suggestions. ...

Crystal report not picking up information
I have a commission report that gathers sales amounts from field "RM20101.RMDTYPAL". We've recently changed service management software and now, after integrating the transactions - the commission report picks up nothing. I have no idea what I need to change - thoughts? Larry, RMDTYPAL stores the type of transaction, like Invoice or Credit Memo, not the sales amounts....is the commissions report basing what it's picking up on that field? Has the change to what is being integrated from the service management software caused a change in what's going into this fiel...

How to retrive password protected worksheet but forgot password?
I password protected an Excel spreadsheet and now can't remember the password. Is there any way that I can gain access to my worksheet? There are tons of FREE good Excel password 'cracking' tools. Your favorite search engine should get about a gazillion hits on a phrase like "crack excel password" or "excel password cracker". A good one that many report great success with can be found at: http://www.straxx.com/excel/password.html "Laurie" wrote: > I password protected an Excel spreadsheet and now can't remember the > p...

centralized management of mail forwarding, out of office replys, i
hi there, -is ist possible to allow/disallow mailforwarding and out of office reply to the internet by USER? ex2k: i can only find that point by DOMAIN not by USER or Groups -is there any way for centralized management of all "mail-forwardings" and "OoO-Replys", for documentation purposes, maybe 3rdparty? tia rt ...

Spreadsheet password protection
How do you password protect a spreadsheet. I can't find anything in the help section. You can prevent un authorised access by giving a password to open the workbook itself, so that no one else can open it (Go to Tools, Options and then Security Tab). You can do it there if you have already saved the file, or you can go to "save as" then "Tools" and "General Options" where you can give password. On the other hand you can protect work sheets and ranges for different people by using "Tools" and then "Protection" Tab -- M Imran Buha...

Chinese Characters in Report
How can Simplified Chinese characters be displayed in a label or textbox on a report? I will need to have some labels and textboxes displaying Simplified Chinese and others displaying English. Is just a font needed or something else? Any advice would be appreciated. -- AG Email: discussATadhdataDOTcom "AG" <NOSPAMa-giam@newsgroups.nospam> wrote in message news:u48MULPiIHA.3940@TK2MSFTNGP05.phx.gbl... > > How can Simplified Chinese characters be displayed in a label or textbox > on > a report? > I will need to have some labels and textboxes displaying S...

Chart Linking Problem
I have a chart linked into my active worksheet. The linked chart is a bar graph whose data is based upon the offset formula which was chosen to automatically update the chart based upon the new month's data. However, my active worksheet will not update the chart. When I try to update it manually I get the message that says: "The name you specified is defined as something other than a rectangular cell reference". Anyone ever see this? Any thoughts on how to work around this? ...

Password
I am working with publisher 2007. I finished my site last Dec. and went to make changes. It is not letting me make changes because it does not like my password. I can not figure out how to go in a reset everything from my provider. Any suggestions. I was also trying to see if I could find web publishing wizard, which doesn't seem to exsist with 2007. Thanks If you are saying you forgot your password then contact the ISP Tech Support and they will reset the password to something like 1 2 3 4 or something other that is very simple. They will also instruct you to change it to somethin...

Change Password Next Login, Enforce Password Policy and Expiration
I'm curious why are the Change Password Next Login, Enforce Password Policy and Enforce Password Expiration is diabled in Greatplains 8.0 when i create a user. my client want to know how to enable it. hope for your prompt action. -- Jeremy Ayaay Technical Specialist STRC Only works for SQL 2005. If you client wants to use a beta database server... "Jher" wrote: > I'm curious why are the Change Password Next Login, Enforce Password Policy > and Enforce Password Expiration is diabled in Greatplains 8.0 when i create a > user. my client want to know how to enab...