Home
Appendices
Required permissions for the Banner username
Ellucian Mobile requires access to several Banner Oracle tables and functions, and uses an Oracle user to connect to the required data.

Implementation Guide, May 2023, Release 5.6.3
This online help contains comprehensive information about how to install, set up, and maintain Ellucian Mobile.
Ellucian Mobile Overview
Ellucian Mobile, powered by Ellucian Ethos, provides faculty, prospects, students, staff, and other constituents with access to key campus information and services from their mobile devices. This section provides an overview of Ellucian Mobile.
Before You Begin
This section describes some advance preparations that you can make to help your Ellucian Mobile setup process to go as smoothly as possible.
Install Supporting Software
Before you can install the Ellucian Mobile components, there are several prerequisite software components that must be installed. Note that Grails is also required, but does not need to be installed separately because all Grails components that you need are included in the WAR file that you install later.
Install Ellucian Mobile Software
Install the Ellucian Mobile WAR file and perform basic configuration steps.
Set up the Mobile Cloud Configuration System
Set up the Ellucian Mobile Cloud Configuration System. Description of the process for signing from the Ellucian Hub, how to create and enter the configuration settings, and how to specify the SIS credentials.
Manage Users and User Permissions for the Mobile Cloud Configuration System
You can give selected people access to modify specific elements of your mobile configurations, such as user management, configuration management, branding, or sending push notifications.
Customize the Appearance of Ellucian GO
Set up the home screen, select background and text colors, and set up the About screen.
Set Up Location-Aware Features
Set up Ellucian Mobile features that are location-aware; that is, based on proximity to a beacon.
Set Up Application Modules
Set up the application modules that are displayed in Ellucian GO.
Test and Publish a Configuration
To view your configuration on a device, you must place the configuration into test status. When you are ready to make your configuration available in the public list of institutions on Ellucian GO, you publish the configuration.
Analyze Usage
The Google Analytics Platform lets you measure user interactions across various devices and environments. You can use Google Analytics to view detailed usage statistics of your school's Ellucian Mobile implementation.
Manage Configurations
In addition to the ability to add a new configuration manually, you can create a new configuration by copying an existing one, export configuration information, import configuration information, and migrate a configuration to a different database.
Set up multiple Mobile Integration Server Web Service Apps
If you want to have multiple active configurations at the same time, you need to set up multiple Mobile Integration Server web service apps.
Set up Load Balancing and Redundancy
Multiple Mobile Integration Servers can be set up for a single configuration. This can be done to scale the solution to support more mobile users, or for redundancy. Deployment of multiple Mobile Servers requires a shared data storage using either a Microsoft SQL Server or an Oracle database.
Ellucian Mobile on Wearable Devices
Users can view push notifications on their Android Wear and Apple Watch devices. Users with Apple Watches can also view ILP assignments and maps.
Debugging
Send detailed information from Ellucian Mobile to the log file to support troubleshooting.
Appendices
- Specify SIS configuration in the config.groovy file
  You can enter SIS configuration information in the <sis>-mobileserver-config.groovy file, as an alternative to specifying that information using the Ellucian Mobile Cloud Configuration tool.
- Required permissions for the Banner username
  Ellucian Mobile requires access to several Banner Oracle tables and functions, and uses an Oracle user to connect to the required data.
- Multiple Configuration Diagram
  Ellucian Mobile multiple configurations diagram.
- Ellucian Mobile Multi-Entity Processing
  Ellucian Mobile supports Banner Multi-Entity Processing (MEP) environments. MEP Banner environments support clients who have multiple institutions/entities sharing the same Banner instance.
- Previous Release Notes
  This section includes the Release Notes from previous Ellucian Mobile releases.

Required permissions for the Banner username

Ellucian Mobile requires access to several Banner Oracle tables and functions, and uses an Oracle user to connect to the required data.

You can use the createBannerMobileUser.sql script to create a Banner user that has all the required permissions. You can find this script in the /sql-scripts/banner/ folder. If you choose to create this user manually, the user must have select access to the following tables:


gobtpac	sfrstcr	slrbcat	spraddr	stvcamp
stvssts	gordadd	sgbstdn	slrbcmt	sprhold
stvdept	stvstst	goremal	shrtckg	slrbdef
spriden	stvfcst	stvterm	govrole	shrtckn
sobptrm	sprtele	stvgmod	twgrrole	scbcrse
sibinst	sobterm	ssbsect	stvhldd	twtvrole
scrlevl	sirasgn	sorrtrm	ssbssec	stvlevl
sfbetrm	sirdpcl	sorwdsp	ssrmeet	stvrdef
sfrareg	slbbldg	spbpers	stvbldg	stvrsts

This user also needs access to the following Oracle functions or packages:

bwcklibs
f_format_name
f_getspridenid
gb_common
gb_hold
scksels
g$_date_pkg

Enter this user name in the Username field when setting up the Banner configuration.

There are also several permissions and a "banproxy" requirement for the Banner Student Web API username. See the Ellucian XE Registry documentation on the Ellucian Customer Center for more information.