Make GA/EM Group

As title saying, I want to make new GA/EM Group in ACCOUNT database

as i understood u wanna notice , uniques only right ?
if so follow me
1 - go to SRO_VT_ACCOUNT ( or whatever its name ) >> Tables >> _SecurityDescriptionGroup

2 - make new line for your group number and name ... make it like this

Quote:

---

20 GA GA

---

i made the number for them 20 you can make any number you want or it might be auto

3 - go to SRO_VT_ACCOUNT ( or whatever its name ) >> Tables >> _SecurityDescriptionGroupAssign

4 - make new line for your group number and name ... make it like this

Quote:

---

20 29

---

i made the number for them 20 because that's the number in _SecurityDescriptionGroup

hope you got it
Enjoy ..

Quote:

---

Originally Posted by RenePunik

As title saying, I want to make new GA/EM Group in ACCOUNT database

---

use this query

Quote:

---

USE SRO_VT_ACCOUNT
delete from _SecurityDescriptionGroupAssign where nGroupID = '10'
INSERT INTO _SecurityDescriptionGroupAssign (nGroupID, nDescriptionID)VALUES ('10', '14')
INSERT INTO _SecurityDescriptionGroupAssign (nGroupID, nDescriptionID)VALUES ('10', '28')
INSERT INTO _SecurityDescriptionGroupAssign (nGroupID, nDescriptionID)VALUES ('10', '29')

---

you can change 10 if it doesn't exist on your _SecurityDescriptionGroup and change it to any number you want . .

What query of two i should use, (thebigbody or ipod4touch) ?

my answer is not a query
that's a little guide
follow it then you will understand ;)

Quote:

---

Originally Posted by thebigbody

my answer is not a query
that's a little guide
follow it then you will understand ;)

---

Thanks i will try it when i not be busy..