Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Administration & Installation

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 28th June 2005, 13:00
shivanand shivanand is offline
Junior Member
 
Join Date: Jul 2003
Location: India
Posts: 23
shivanand is on a distinguished road
Baan: c4 - DB: informix - OS: Solaris8
password protecting a table for super user

Hi ,
How can i deny a super user from accessing one particular table .
For eg. I want the super user should not be able to see the table tfgld011.
__________________
Regards:
Shivanand Mali
Reply With Quote
  #2  
Old 28th June 2005, 13:29
dave_23's Avatar
dave_23 dave_23 is offline
Guru
 
Join Date: Oct 2002
Location: Portland, OR
Posts: 1,303
dave_23 will become famous soon enough
Baan: All - DB: Oracle / MS SQL / DB2 - OS: All
You can't with standard Baan.. you'd have to do something tricky at the DB level, but that would be likely to lead to fatal errors more than anything else.

Superusers are for admin personnel - regular (non-IT) users should (and can) just be regular users with the correct level of permissions set.

Dave
Reply With Quote
Sponsored Links
  #3  
Old 29th June 2005, 12:31
suhas-mahajan's Avatar
suhas-mahajan suhas-mahajan is offline
Guru
 
Join Date: Jan 2003
Location: Pune
Posts: 458
suhas-mahajan is an unknown quantity at this point
Baan: IV C4 IN3, IN5, IS5, LN - DB: Oracle 8.0.5, 9i, Informix - OS: Win NT, 2K, 2K3, AIX
Hmmm...Not understood your aim.

I think, planning to hide from BOSS

But you can use Flat file for reading/writting purpose, which can be hide and kept on server side under hidden folder.

Hope this helps.

regards,

-Suhas
Reply With Quote
  #4  
Old 30th June 2005, 04:34
Paul P's Avatar
Paul P Paul P is offline
Guru
 
Join Date: Jul 2002
Location: Jakarta, Indonesia
Posts: 797
Paul P is on a distinguished road
Baan: BaanIV, BaanERP - DB: SQL Server, Informix, Oracle - OS: Windows, HP-UX
Don't make him/her super user

Rgds,
Paul
__________________
Pambudi

Visit my technology consulting blog
Reply With Quote
  #5  
Old 4th July 2005, 14:37
Rita Kotecha Rita Kotecha is offline
Senior Member
 
Join Date: Oct 2003
Location: Mumbai
Posts: 214
Rita Kotecha is on a distinguished road
Baan: Baan Vc - DB: SQL 2k - OS: Win 2k
Intresting !!

Can you explain me where exactly did you need this. Restricting Super user ??
__________________
Regards
Rita
Reply With Quote
  #6  
Old 4th July 2005, 16:47
shivanand shivanand is offline
Junior Member
 
Join Date: Jul 2003
Location: India
Posts: 23
shivanand is on a distinguished road
Baan: c4 - DB: informix - OS: Solaris8
Password protect table

Hi,
This thing just came in my mind. Also the reason being , if you have your developers as super users and one doesnt want to allow them to view the finance tables /some important tables then this would come handy.
__________________
Regards:
Shivanand Mali
Reply With Quote
  #7  
Old 4th July 2005, 16:53
Rita Kotecha Rita Kotecha is offline
Senior Member
 
Join Date: Oct 2003
Location: Mumbai
Posts: 214
Rita Kotecha is on a distinguished road
Baan: Baan Vc - DB: SQL 2k - OS: Win 2k
Hi,

I feel the best to handle your query is create a role "Developers".

Assign the proper authorizations to the developers so that they can access tools module and the required tables and table fields. You can restrict the access to the table field which is very sensitive for this set of users.

But see that they are not super users.
__________________
Regards
Rita
Reply With Quote
  #8  
Old 5th July 2005, 05:25
shivanand shivanand is offline
Junior Member
 
Join Date: Jul 2003
Location: India
Posts: 23
shivanand is on a distinguished road
Baan: c4 - DB: informix - OS: Solaris8
ok

Ok thanxs for all the replies.
__________________
Regards:
Shivanand Mali
Reply With Quote
  #9  
Old 5th July 2005, 21:38
NPRao's Avatar
NPRao NPRao is offline
Guru
 
Join Date: Aug 2001
Location: Pacific NW, USA
Posts: 3,028
NPRao will become famous soon enough
Baan: iBaanERP-5.2a(Reger),SSA-ERP-LN-6.1,Infor LN-10.x - DB: Oracle-10g,11g,12c,MS-SQL - OS: HP-UX, Linux, Windows
Lightbulb

Shivanand,
Quote:
if you have your developers as super users and one doesnt want to allow them to view the finance tables /some important tables then this would come handy.
as Rita suggested you shouldnt have any Super Users on system than the BaaN Administrators, and the rest can be normal users with role authorizations.
Quote:
How can i deny a super user from accessing one particular table .
You can always do that for any session irrespective of BaaN-normal/super-users, similar to the GTM.
Here is an idea-

Call the Check Password session - ttadv0145m000 in the before.program section in your program, and continue if successful, abort if failure.

-OR- write your own program which can do the password check based on package specific tables etc.
__________________
The art of perfection does not lie in doing extraordinary things but, doing ordinary things extraordinarily well. [-N. Prashanth Rao]
How To Ask Questions The Smart Way,BaaNBoard,NPRao
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Force User Change Password At Next Login mila04792 Tools Administration & Installation 5 4th March 2005 03:26
Tables used for MRP and PRP. BurghMan Tools Development 1 10th February 2005 14:08
copy records c_siek Tools Development 9 18th June 2004 15:43
Zoom Session for selection bklunder Tools Development 1 27th November 2003 07:25


All times are GMT +2. The time now is 07:15.


©2001-2017 - Baanboard.com - Baanforums.com