on 08-25-2011 7:23 PM
Hello,
Signed up a user in SAP B1 and saw that the code was wrong, was minuscule, and tried to delete it again only register that gave error saying it already existed.
I realized that deleting the user, it changes the group table OUSR from 0 to 99
I wonder if I can run the following command window using the "Query Manager"
"update ousr set groups=0 where userid = 35"
The user is new, never been used,
Thank's
Fabio.
PS: sorry for the syntax, I'm using google translator
Hi Fabio,
Any direct update by SQL is not supported. You should not try it. Only SAP support team or authorized Partner could run certain scripts. Do not run by yourself.
Thanks,
Gordon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
the execution is not a direct access, but from within the SAP, the window "Query Generador".
My question is this, in document "Whats New" version 8.8 reads
- Security Enhancements -
"...To improve data integrity in the database, a new permission allows specified SAP Business One users to run only selected read-only queries on the company database through SAP Business One's query editors...."
that means I could, with caution, run update queries from within SAP B1, since there is even the option to permit users to run only "selects" (read-only) tables.
thus, the "manager" could do an "update" from within the system, correct?
Regards,
Fabio.
User | Count |
---|---|
106 | |
14 | |
10 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.