2. PHPRunner General questions
  3. [SOLVED] Relate security options with an existing database
This topic is locked
[SOLVED]

Relate security options with an existing database

 		7/15/2021 3:40:53 PM
PHPRunner General questions
D
 Daviant author

Dear;
I am writing here for guidance regarding a project.
I need to access from a website to a SQLSERVER server with Windows Server 2016 and obtain certain information for users.
The database already exists and has the information stored. Specifically, how the security options of PHPrunner can be used so that they can create users on the web and through some field allow the visualization of the information that SQL Server contains only that field.
I appreciate any suggestions.

Google translator
HJB 7/16/2021

Dynamic user group permissions

Above URL content is a good guide of what can be made possible. Further, in regard to just visualize only
one field, the following URL provides useful information on how to list or not list a field and how to activate
its display or not by using "columns by device" features.

Choose fields screen
D
 		Daviant author 7/21/2021

Thanks for the reply. I have made progress with dynamic permissions, but I am stuck in something that should be simple, but it does not work for me.
I intend to use the Username field of the security Api to link it to a field in a table, but it generates an error.

Username: Varchar (255)
RTEN Char (13)

In List page, before process, I have the following:

$ userData = Security :: getUserName ();
$ userData = ltrim ($userData);
global $ conn;
$ strSQLExists = "SELECT * from MAEEN where LTRIM (RTEN) =". $ userData. "";
$ rsExists = db_query ($ strSQLExists, $ conn);

Well, the query runs, but it lists the entire table, and it should show only one record ...
Obviously something is wrong, so I ask for guidance in this regard ...

Thank you

(Google Translate)