No only connection level, otherwise if its set at the DB level everything will still have the same priority that accesses the DB, so your not changing anything from the default way SQL works.