Results 1 to 5 of 5

Thread: Standard SQL Users & Permissions

  1. #1
    Senior Member Crazy_About_JDE's Avatar
    Join Date
    Jul 2003
    Location
    Indianapolis
    Posts
    224

    Standard SQL Users & Permissions

    Hello, List! Can someone point me to a document that lists the standard users with their default database and special permissions (system administrator, server administrator, etc.) created in MSSQL by OneWorld Xe during installation?

    Muchas gracias, in advance!

    -Tim

    Indianapolis JDE/PeopleSoft Regional User Group last met June 2009
    http://indypsjderug.blogspot.com/

    OneWorld B7334 Upd 1 SP23_J1
    iSeries V5R3, iTera Echo2
    IMS/21 document imaging

  2. #2
    Senior Member
    Join Date
    Jun 2001
    Location
    CA
    Posts
    126

    Re: Standard SQL Users & Permissions

    Tim,

    I can't point you to the document, but I can give you an FYI that DBA's should be aware of - by default during a JDE install, the public role is given all permissions to all JDE database tables. And, even if you change this, each time a table is re-generated, it will default back to giving public all permissions.

    We found out from JDE that this expected behavior, and it was up to us to change the permissions. We ended up writing a script to change them on a global scale and then and creating a process to manually change them on each table when we re-generate it.

    We're using SQL Server 2000.
    Shelley M. Maas
    Development Manager
    Apio, Inc.
    -------------------
    OneWorld XE / Update 7 / SP 22 S1

  3. #3
    Member
    Join Date
    May 2002
    Location
    Hong Kong
    Posts
    37

    Re: Standard SQL Users & Permissions

    Yes, I have the same experience and we are using Oracle 8i.

    Regards,
    Alvin
    Xe, Oracle 8.1.7, AIX 4.3, Citrix on NT

  4. #4
    Senior Member Crazy_About_JDE's Avatar
    Join Date
    Jul 2003
    Location
    Indianapolis
    Posts
    224

    Re: Standard SQL Users & Permissions

    Forgive my naivete. What do you have to change permissions to?
    Indianapolis JDE/PeopleSoft Regional User Group last met June 2009
    http://indypsjderug.blogspot.com/

    OneWorld B7334 Upd 1 SP23_J1
    iSeries V5R3, iTera Echo2
    IMS/21 document imaging

  5. #5
    Senior Member
    Join Date
    Jun 2001
    Location
    CA
    Posts
    126

    Re: Standard SQL Users & Permissions

    Well, you typically don't want public to have any permissions, other than perhaps read (we don't even want that), since, if anyone makes an ODBC connection to your databases, they'll have full access to read and write outside of JDE. So if you're like us, you'll want to remove all permissions.

    You can do this either through the GUI (it would be a pretty arduous process when you are changing permissions in bulk) or through scripting. You do have to make sure that you've given the JDE user(s) necessary permissions before removing them from the public role, as by default, they are just inheriting whatever the public role has.

    If you're new to SQL Server and don't have a DBA handy, I highly recommend reading about security and roles in the SQL Server Books Online. I could also send you the script we used to make the initial permission changes, but you're going to want to feel comfortable with the product before running such a script.
    Shelley M. Maas
    Development Manager
    Apio, Inc.
    -------------------
    OneWorld XE / Update 7 / SP 22 S1

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.