User Level Access setup for FORMS Question
Posted: Sun Dec 16, 2012 11:47 pm
First, I would like to thank all those involved in this project. Well done, and to the point.
Looking in the forum here, and general tutorials I am not able to find a solution to the problem I have encountered.
There are a few similar posts, but no solutions to the following issue:
Unable to add a form for a group level access
Here is the rundown.
version
nubuilder-v2.8-12.12.11-Build550.tar
PHP 5.3.3-14.el6_3
MySQL 5.1.61-4.el6
CentOS 6.3 (Final)
nuBuilder installation was fine
I used the sample.sql to add the zzsys_ tables to my existing DB
commented out
-- CREATE DATABASE IF NOT EXISTS sample;
-- USE sample;
-- CREATE USER 'sample'@'localhost' IDENTIFIED BY 'samplepass';
-- GRANT ALL PRIVILEGES ON `sample` . * TO 'sample'@'localhost' WITH GRANT OPTION;
-- SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
-- SET time_zone = "+00:00";
All went fine with SQL.
logged in with globeuser and PW, -- OK
Created Object and used form wizard to make a form for view and mod of an existing table -- OK
Added a User Group, User -- OK
Added access Level, chose the group, added object OK
***** added Form == !OK (not OK)
{the selection window with a list of the forms shows up but none can be clicked on to be added} This appears to be a static list.
I can log in with the added user credentials
Button works, ( set up for TAB ) but cannot view the form
error said ~ no access. " You do not have access "
I tried the hidden button trick and made a mess. The form can only be seen when the form is set to Access with out Login = Yes... however, the whole link now is live with no session password. If it is set to no, you will see ~ no access. "You do not have access"
I typed in the name of the form from the list:
The result is: ' Forms Allowed Access' on line 1 cannot be left blank ( upon save. )
Anything I missed?
Thanks
Mike
Looking in the forum here, and general tutorials I am not able to find a solution to the problem I have encountered.
There are a few similar posts, but no solutions to the following issue:
Unable to add a form for a group level access
Here is the rundown.
version
nubuilder-v2.8-12.12.11-Build550.tar
PHP 5.3.3-14.el6_3
MySQL 5.1.61-4.el6
CentOS 6.3 (Final)
nuBuilder installation was fine
I used the sample.sql to add the zzsys_ tables to my existing DB
commented out
-- CREATE DATABASE IF NOT EXISTS sample;
-- USE sample;
-- CREATE USER 'sample'@'localhost' IDENTIFIED BY 'samplepass';
-- GRANT ALL PRIVILEGES ON `sample` . * TO 'sample'@'localhost' WITH GRANT OPTION;
-- SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
-- SET time_zone = "+00:00";
All went fine with SQL.
logged in with globeuser and PW, -- OK
Created Object and used form wizard to make a form for view and mod of an existing table -- OK
Added a User Group, User -- OK
Added access Level, chose the group, added object OK
***** added Form == !OK (not OK)
{the selection window with a list of the forms shows up but none can be clicked on to be added} This appears to be a static list.
I can log in with the added user credentials
Button works, ( set up for TAB ) but cannot view the form
error said ~ no access. " You do not have access "
I tried the hidden button trick and made a mess. The form can only be seen when the form is set to Access with out Login = Yes... however, the whole link now is live with no session password. If it is set to no, you will see ~ no access. "You do not have access"
I typed in the name of the form from the list:
The result is: ' Forms Allowed Access' on line 1 cannot be left blank ( upon save. )
Anything I missed?
Thanks
Mike