vb.net - Capturing user who changes database -

-

i work on few projects front end moved vb.net, back-end's remain in access .accdb format.

with access front end able set data macros captured username of person making changes , record them in audit table, looks little harder .net front-end.

is there way pass information front end database ? or there method of making back-end @ function stored there (it doesn't seem work @ moment)

this code have in back

private declare function apigetusername lib "advapi32.dll" alias _ "getusernamea" (byval lpbuffer string, nsize long) long  public function getusername() string ' returns network login name dim lnglen long, lngx long dim strusername string     strusername = string$(254, 0)     lnglen = 255     lngx = apigetusername(strusername, lnglen)     if lngx <> 0         getusername = left$(strusername, lnglen - 1)     else         getusername = ""     end if end function

i have public function doing same in front-end, called getusername()

my friend, here we're talking principal differences between working within enclosed environment of ms access, not database application. since inside access native itself, have access internals. moving away model , design should change accordingly. here in, lets call client-server environment, , client knows little besides connection string , server knows nothing client.

this not issue how retrieve user name or other information code. goal design system support auditing. have audit table - good.

depending on security model, either use user name of machine user, or user name of application user. have - in vb easy.

without knowing audit structure, can tell way done, when data changing, create sql transaction using ado.net, , under transaction insert audit data , crud on real data. commit. way, either succeed or fail both - no data modified without audit.

now, step add table (if don't have already) 4 fields:

createdby, creteddate, modifiedby, modifieddate.

each record ready display playing system , when.

and how access db gets user:

  1. via sql contains user column , data "insert ... values('" & user & "', ...."
  2. via separate audit call contains user name
  3. via stored procedure 1 parameter can dedicated pass user info

Comments

Post a Comment

Popular posts from this blog

Android : Making Listview full screen -

-
<linearlayout xmlns:android="http://schemas.android.com/apk/res/android" xmlns:tools="http://schemas.android.com/tools" android:layout_width="match_parent" android:layout_height="match_parent" android:orientation="vertical" tools:context=".mainactivity"> <edittext android:layout_margintop="5dp" android:layout_width="match_parent" android:layout_height="50dp" android:background="@drawable/location_edittext" android:id="@+id/locationeditext" android:textsize="15sp" android:textcolor="#999" android:paddingleft="15dp" /> <com.example.ravi_gupta.slider.viewpagercustomduration android:layout_width="wrap_content" android:layout_height="0dp" android:id="@+id/viewpager" android:scrollbarstyle="outsideoverlay" android:layout_weight="0.5...
Read more

javascript - Parse JSON from the body of the POST -

-
i'm using cameratag.com record video on website. service can send json response server can save data database. don't know how proceed here: the documentation states please note json repsonse passed in body of post , not form parameters. here example of how parse response in ruby: data = json.parse(request.raw_post) video_uuid = data["uuid"] but don't know how data on javascript. i'm not experienced in js please bare me :) post sample: { "uuid": "00012710-4b65-0131-ffe6-22000a499ea4", "camera_uuid": "98373a20-79ee-0130-3e42-1231390fcc11", "created_at": "2013-12-20t05:25:02.000z", "percent_complete": 100, "short_code": "kktb4q", "metadata": { }, "state": "published", "recorded_from": "http://singwho.com", "publish_type": null, "formats": [ { "name...
Read more

python - No response in ssh.exec_command in paramiko -

-
i trying use python paramiko execute commands on remote server. when run following commands prompt , appears have succeeded prompt back >>> import paramiko >>> ssh = paramiko.sshclient() >>> ssh.set_missing_host_key_policy(paramiko.autoaddpolicy()) >>> ssh.connect('a.b.c.d', username='server', password='xyz') >>> the response when try execute command [] >>> stdin, stdout, stderr = ssh.exec_command("host") >>> stdout.readlines() [] almost command gives same output. command "host" when ssh executed shell gives several lines of usage output i error if don't give password >>> ssh.connect('a.b.c.d', username='server') traceback (most recent call last): file "<stdin>", line 1, in <module> file "build\bdist.win32\egg\paramiko\client.py", line 307, in connect file "build\bdist.win32\egg\paramiko\client.py...
Read more