search

omar733 / company-time-sheet

Automatically exported from code.google.com/p/company-time-sheet
0 stars 0 forks source link

SP NEED FOR USER RIGHTS FORM #83

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
NEED SP FOR USER RIGHTS FORM

1.ROLE CREATION AND SEARCH/UPDATE SAVE PART
2.LOGIN CREATION AND SEARCH/UPDATE SAVE PART
3.SP TO SAVE N UPDATE BASIC MENU PROFILE N ROLE PROFILE 
4.USER RIGHTS TERMINATE AND REJOIN SP .

CHECK EI USER RIGHTS SP.SAME AS EI

Original issue reported on code.google.com by SAFIYULL...@ssomens.com on 28 Aug 2014 at 4:12

GoogleCodeExporter commented 9 years ago

Original comment by RAJALAKS...@ssomens.com on 1 Sep 2014 at 5:08

GoogleCodeExporter commented 9 years ago 
started working on user rights sp

Original comment by RAJALAKS...@ssomens.com on 1 Sep 2014 at 5:08

GoogleCodeExporter commented 9 years ago 
@RAJA

WRITE SP 

1.SP TO SAVE N UPDATE BASIC MENU PROFILE N ROLE PROFILE 
2.USER RIGHTS TERMINATE AND REJOIN SP .

Original comment by dhivya.a...@ssomens.com on 1 Sep 2014 at 5:27

GoogleCodeExporter commented 9 years ago 
user rights sp is onhold working on issue 78 comment no#35

Original comment by RAJALAKS...@ssomens.com on 1 Sep 2014 at 5:39

GoogleCodeExporter commented 9 years ago 
@RAJA

WRITE SP

1.ROLE CREATION AND SEARCH/UPDATE SAVE PART
2.LOGIN CREATION AND SEARCH/UPDATE SAVE PART

CHECK EI USER RIGHTS SP.SAME AS EI

Original comment by RAJALAKS...@ssomens.com on 3 Sep 2014 at 5:19

GoogleCodeExporter commented 9 years ago 
RL completed the sp for change userstamp as uldid

DRIVE LINK : 
https://drive.google.com/a/ssomens.com/?tab=mo#folders/0Bwv4Rd7ZecjPSWVJOFVyOExH
QTg

FILE NAME : SP_TS_CHANGE_USERSTAMP_AS_ULDID_VER_0.1_83_1_01092014.SQL

as per comment no#3 raja completed the SAVE N UPDATE SP FOR BASIC MENU PROFILE 
N ROLE PROFILE & USER RIGHTS TERMINATE AND REJOIN SP 

DRIVE LINK : 
https://drive.google.com/a/ssomens.com/?tab=mo#folders/0Bwv4Rd7ZecjPd2pLd1I1NHVP
MzQ

FILE NAME : SP_TS_LOGIN_CREATION_INSERT_VER_0.1_83_3_02092014.sql
FILE NAME : SP_TS_LOGIN_TERMINATE_SAVE_VER_0.1_83_3_02092014.sql
FILE NAME : SP_TS_USER_RIGHTS_BASIC_PROFILE_SAVE_VER_0.1_83_3_01092014.sql
FILE NAME : SP_TS_USER_RIGHTS_BASIC_PROFILE_UPDATE_VER_0.1_83_3_01092014.sql

Original comment by RAJALAKS...@ssomens.com on 3 Sep 2014 at 5:29

GoogleCodeExporter commented 9 years ago 
test the delivery in comment no#6

Original comment by RAJALAKS...@ssomens.com on 3 Sep 2014 at 5:30

GoogleCodeExporter commented 9 years ago 
as per comment #5 raja delivered role creation insert & update and login update 
sp

drive 
link:https://drive.google.com/a/ssomens.com/?tab=mo#folders/0Bwv4Rd7ZecjPd2pLd1I
1NHVPMzQ

file name:SP_TS_ROLE_CREATION_UPDATE_VER_0.1_83_5_03092014.sql
file name:SP_TS_ROLE_CREATION_INSERT_VER_0.1_83_5_03092014.sql
file name:SP_TS_LOGIN_UPDATE_VER_0.1_83_5_03092014.sql

Original comment by dhivya.a...@ssomens.com on 4 Sep 2014 at 4:09

GoogleCodeExporter commented 9 years ago 
copy the user rights view used in EI to timesheet also.we need that view.

Original comment by SAFIYULL...@ssomens.com on 16 Sep 2014 at 11:39

GoogleCodeExporter commented 9 years ago 
USER RIGHTS VIEW MOVED IN TIMESHEET

DRIVE 
LINK:https://drive.google.com/a/ssomens.com/?tab=mo#folders/0B_f0d7mdbV_UYzN3Z2c
tYlRkR2M

FILE NAME:VW_ACCESS_RIGHTS_TERMINATE_REJOIN_LOGINID_VER_0_1_16092014.SQL

Original comment by dhivya.a...@ssomens.com on 16 Sep 2014 at 12:14

GoogleCodeExporter commented 9 years ago 
same site maintanence sp in EI need here also, move to timesheet also. check 
and move

Original comment by SAFIYULL...@ssomens.com on 18 Sep 2014 at 11:38

GoogleCodeExporter commented 9 years ago 
@RAJA

CHECK AND MOVE SITE MAINTANENCE SP FROM EI TO TS FOLDER

Original comment by dhivya.a...@ssomens.com on 18 Sep 2014 at 11:40

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT NO 12 CREATED SITE MAINTENANCE SP FOR TIME-SHEET LIKE EI SITE 
MAINTENANCE SP.

FILE NAME:
SP_TS_ACCESS_RIGHTS_SITE_MAINTENANCE_VER_0.1_83_12_18092014

DRIVE LINK:
https://drive.google.com/a/ssomens.com/?tab=mo#folders/0B_f0d7mdbV_UYzN3Z2ctYlRk
R2M

Original comment by raja.gun...@ssomens.com on 18 Sep 2014 at 1:27

GoogleCodeExporter commented 9 years ago 
TEST DELIVERY IN THE COMMENT #13

Original comment by dhivya.a...@ssomens.com on 18 Sep 2014 at 1:40

GoogleCodeExporter commented 9 years ago 
need join date in VW_ACCESS_RIGHTS_TERMINATE_REJOIN_LOGINID , so include and 
deliver

Original comment by SAFIYULL...@ssomens.com on 20 Sep 2014 at 7:09

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT #15 CHANGE USERRIGHTS VIEW & DELIVER

Original comment by dhivya.a...@ssomens.com on 20 Sep 2014 at 10:38

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT NO 15 ADDED JOIN DATE COLUMN IN 
VW_ACCESS_RIGHTS_TERMINATE_REJOIN_LOGINID.

FILE NAME:
SP_TS_VW_ACCESS_RIGHTS_TERMINATE_REJOIN_LOGINID_VER_0.2_83_15_22092014

DRIVE LINK:
https://drive.google.com/a/ssomens.com/#folders/0B_f0d7mdbV_UYzN3Z2ctYlRkR2M

Original comment by raja.gun...@ssomens.com on 22 Sep 2014 at 5:08

GoogleCodeExporter commented 9 years ago

Original comment by dhivya.a...@ssomens.com on 22 Sep 2014 at 5:31

GoogleCodeExporter commented 9 years ago 
in login updation, need to update login id also. change the sp and deliver.then 
include the field emp type in login creation and search/update sp

Original comment by SAFIYULL...@ssomens.com on 10 Oct 2014 at 6:26

GoogleCodeExporter commented 9 years ago

Original comment by dhivya.a...@ssomens.com on 10 Oct 2014 at 7:41

GoogleCodeExporter commented 9 years ago

Original comment by dhivya.a...@ssomens.com on 10 Oct 2014 at 7:41

GoogleCodeExporter commented 9 years ago 
AS PER COMMENT #19 COMPLETED LOGIN CREATION & UPDATE SP

DRIVE 
LINK:https://drive.google.com/a/ssomens.com/?tab=mo#folders/0B_f0d7mdbV_UYzN3Z2c
tYlRkR2M

FILE NAME:SP_TS_LOGIN_CREATION_INSERT_VER_0.2_83_19_10102014.SQL
FILE NAME:SP_TS_LOGIN_UPDATE_VER_0.1_83_19_10102014.SQL

Original comment by dhivya.a...@ssomens.com on 10 Oct 2014 at 12:05

GoogleCodeExporter commented 9 years ago

Original comment by dhivya.a...@ssomens.com on 10 Oct 2014 at 12:05