voedger / voedger

MIT License
5 stars 11 forks source link

parser, appdef: Tags #2792

Open maxim-ge opened 2 weeks ago

maxim-ge commented 2 weeks ago

Requirements

mail2nnv commented 1 day ago
--
-- Tags usage
--

WORKSPACE wsOne {
  TAG tagOne

  TABLE tableOne INHERITS sys.CDoc {
  } WITH TAG tagOne
}

WORSPACE wsDescendant INHERITS wsOne {
  TABLE tableDescendant INHERITS sys.CDoc {
  } WITH TAG tagOne -- available
}

WORSPACE wsParent {
  USE WORKSPACE wsChild

  TABLE tableParent INHERITS sys.CDoc {
  } WITH TAG tagOne -- unavailable
}
--
-- Grant/revioke usage
--

WORKSPACE wsOne {
  TABLE tableOne INHERITS sys.CDoc {  }

  ROLE roleOne
  GRANT ALL ON tableOne TO roleOne
}

WORSPACE wsDescendant INHERITS wsOne{
  TABLE tableDescendant INHERITS sys.CDoc {  }

  GRANT ALL ON tableDescendant TO roleOne -- available

  ROLE roleDesc
  GRANT ALL ON tableOne TO roleDesc -- available
  GRANT INHERITS ON roleOne TO roleDesc -- available
}

WORSPACE wsParent {
  USE WORKSPACE wsOne

  TABLE tableParent INHERITS sys.CDoc {  }

  GRANT ALL ON tableParent TO roleOne -- unavailable

  ROLE roleParent
  GRANT ALL ON tableOne TO roleParent -- unavailable
  GRANT INHERITS ON roleOne TO roleParent -- unavailable
}